This discussion is archived
7 Replies Latest reply: Mar 26, 2007 2:38 AM by 423625 RSS

Function for first day of year

146955 Newbie
Currently Being Moderated
Can somebody help me with a custom function in PLSQL to get the first day of a given year.
For example if the date entered by user is 17-Jun-1984, I should get 1-Jan-1984.