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!

Date getting truncated automatically

2773406Oct 14 2014 — edited Dec 3 2014

The Date gets trucated automatically while converting to timestamp.Ex:-

select extract(year from (TO_TIMESTAMP(to_date('14/10/2014','dd/mm/yyyy'), 'dd/mm/yyyy'))) from dual;

this will return the year as 0014 instead of 2014.

I think this should not happen as the specific year is specified without any ambiguity to the system. Any suggestion why this is happening, got totally confused??

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2014

Added on Oct 14 2014

#date

5 comments

1,879 views