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!

get date from base dat + interval (nanoseconds)

chrissy2Feb 27 2008 — edited Feb 27 2008
Hi,

I'm using the DBMS_LDAP package for getting some information about the users.
There's an attribute accountExpires returning the number of 100 nanosecond intervals since January 1, 1601 (UTC).
How can I convert this value the way, that the date is shown.
For example from January 1, 1601 to March 28, 2008 it is 128512188000000000
16010101 (YYYYMMDD) + this interval should return 20080326.

Can this somehow be done???

Thanks
chrissy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2008
Added on Feb 27 2008
2 comments
638 views