7 Replies Latest reply: Feb 25, 2009 12:22 AM by 418213 RSS

    How to convert the SYSDATE to number?

    620516
      Hi,

      How to convert the SYSDATE to number?


      For example :

      1. It is in number 39867.3671

      Now I convert to date

      SELECT TO_DATE('01011900','ddmmyyyy')+39867.3671 FROM DUAL

      Result : 25/02/2009 08:48:37

      How to convert the above date to number ? and SYSDATE to number?

      Please reply



      Thanks
      Nihar