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 returned from Active Directory to and Oracle Date

robenourFeb 16 2005 — edited Feb 16 2005

A developer is using the dbms_ldap package to query data from an Active Directory server. The data returned is a 64 bit number that represents a date as the number of seconds from some date/time. Similar to how Oracle stores dates.

How can that number be converted to an Oracle date datatype? I'm guessing the first thing I'd need is the base date/time that is used by Active directory.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2005

Added on Feb 16 2005

#general-database-discussions

1 comment

393 views