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!

One in a million?

467165Feb 10 2006 — edited Feb 10 2006

I'm accessing a third-party's app database that uses Oracle. I'm asked to find the last accessed dates and things like that. In the tables is a number in that column, that has the NUMBER(20,0) datatype. I tried converting one value with PHP, and it states the converted date is in 2010. That's probably not the last time the database was accessed. The system time on the server is correct, the application does correctly display the last accessed times, I just want to get them straight from the db. Here's an example of one of the values. Can anyone crack it and tell me what the algorithm is?

1139438721429

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2006

Added on Feb 10 2006

#general-database-discussions

2 comments

178 views