Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert from Datetime to number?

620516Mar 30 2010 — edited Mar 30 2010
chg_date_time

40265.492


SELECT c.chg_date_time, TO_DATE('01011900','DDMMYYYY')+CHG_DATE_TIME FROM CHNGHIST C



After execute:
30/03/2010 11:48:29


In the above query, we convert number to datetime.



Now I want to convert from Datetime to number.


i.e., 30/03/2010 11:48:29 = ? (40265.492)



Thanks
Nihar
This post has been answered by Sven W. on Mar 30 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2010
Added on Mar 30 2010
3 comments
4,120 views