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!

To_date

kdAug 28 2007 — edited Aug 31 2007

HI,
if i write a query like this ,

select to_date('01-jan-48','dd-mon-yy') from dual

i am getting the o/p 1/1/2048

but i need the output 1/1/1948 .

How should i write the query..
regards,
Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2007

Added on Aug 28 2007

10 comments

516 views