7 Replies Latest reply: Mar 26, 2007 4:38 AM by 423625 RSS

    Function for first day of year

    146955
      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.

      Thankyou
      Kelvin