Oracle Database Discussions

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!

Convert Date to Long

448590Mar 17 2009 — edited Mar 17 2009

Hallo,

can I convert a date to long?

Or can I convert a date to a number? I already tried this but I get the ora:01722. And don't know why.

SELECT
LASTCHANGE,
to_number(to_char(LASTCHANGE,'MM/DD/JJJJ HH24:MI:SS')) test
FROM table1;

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 17 2009

#general-database-discussions

4 comments

6,349 views