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!

subtract 1 hour from date

636387May 11 2009 — edited May 11 2009

Hi

I have query like this

SELECT TO_CHAR(SYSDATE,'HH24:MI:SS') FROM DUAL

Here i want to minus the 1 hour

Please help me in this issue........

Thanks
Reddy.

Edited by: user633384 on May 11, 2009 12:00 AM

Edited by: user633384 on May 11, 2009 12:02 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2009

Added on May 11 2009

7 comments

159,852 views