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!

How to handles daylight saving time change

0614Nov 16 2020

Hi ALL,
i am converting date from EST to CET getting error like below
ORA-01878: specified field not found in datetime or interval
example :-TO_DATE('08-MAR-2020 02:59:59','DD-MON-YYYY HH24:MI:SS')
please help to resolve this issue in DST and normal

This post has been answered by mathguy on Nov 18 2020
Jump to Answer
Comments
Post Details
Added on Nov 16 2020
9 comments
4,968 views