Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Convert Unix timestamp to Oracle Date

202153Apr 21 2005 — edited Apr 21 2005
I need to convert a unix timestamp that is stored in a varchar2 data type column.

Example..

1113135689000

Any insight ?

Comments

245446
.NET CF is not yet supported by Oracle 9i Lite, it's scheduled for partial support in the patch 5.0.2.8, which is due out September 15th, and full support in the new version 9.0.2 (they are changing the version from 5.X.X too 9.X.X so that Lite and the rest of Oracle is at the same version number) which is scheduled for December 1st...of course as we all know those dates can change.

Shaun
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2005
Added on Apr 21 2005
5 comments
112,066 views