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!

NEW_TIME : Central European Time to GMT

204773Aug 20 2007 — edited Aug 20 2007

I execute this request

SELECT NEW_TIME(sysdate, 'CET', 'GMT') "Central European Time to GMT" FROM DUAL

=>
and i have this error:
Oracle error: ORA-01857: ce n'est pas une plage horaire valide (sev 1, MsgNo 1857).

So, help please

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2007

Added on Aug 20 2007

3 comments

898 views