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!

Convert large int to date/time

446249Oct 14 2009 — edited Oct 14 2009

Hi. We're trying to convert the lastLogon large integer value from the LDAP to a readable date format using this on 10g:

select to_char(to_date('01-01-1601', 'MM-DD-YYYY') + 128660628911406250/(60*60*24*1000*1000*10), 'MM-DD-YYYY HH24:MI:SS') lastLogon from dual

The lastLogon in question is 128660628911406250. Are we using the right formula? It returns +09-16-2008 18:21:31+. Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2009

Added on Oct 14 2009

6 comments

2,691 views