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!

Insert as Integer & Select as Date

391669Nov 30 2003 — edited Dec 2 2003

Hi,

One column's type is 'Integer', when I insert value into this column, I use System.currentMillus() (in Java program) to insert the data.

When I select the value of this field, the return value is displayed like "1.0528E+12".For the view convenience, I want to find a function to convert the Integer to Date format.

In java language, the System.currentMillus() returns the value of seconds that elapse since 1970-01-01,0:00:00am.

Can anybody recommend any PL/SQL function to me? Thank you very much in advance!

BR/Shirley

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2003

Added on Nov 30 2003

4 comments

218 views