Oracle SQL tips and tricks + Unix/Linux Work Log
See how much a single Oracle SQL statement can do... Plus some Unix/Linux Work Log
Friday, August 11, 2006
Converting Unix time_t to Oracle Date
select to_date(19700101, 'YYYYMMDD') + unix_time_t/(24*60*60) from dual;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment