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.

TIMESTAMP format in LINUX based server.

953667Oct 1 2012 — edited Oct 2 2012

Hello masters,

My PLSQL program returns a TIMESTAMP value. Its returning in correct format(03-APR-02 08.45.22.751880000 AM) in UNIX based server.

But in LINUX based server, its returning in wrong format(2002-04-28T09:11:52.409692000).
And when we are passing the same value to another PLSQL program as input and capturing in a variable of TIMESTAMP type, Its raising an error ''ORA-01843: not a valid month".
Please advice me how to handle this in to local timestamp format.

Thanks in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2012

Added on Oct 1 2012

10 comments

316 views