This discussion is archived
7 Replies Latest reply: Feb 24, 2009 10:22 PM by 418213 RSS

How to convert the SYSDATE to number?

620516 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points