Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> update hour in date field

update hour in date field

From: <h_srs_at_hotmail.com>
Date: Sun, 16 Sep 2007 22:02:14 -0700
Message-ID: <1190005334.401663.210680@19g2000hsx.googlegroups.com>


Hello,
I need to update the hour part of a date field, say the field name is createddate.

Like if its value is 17-SEP-2007 21:00:00, I need to update it as 17- SEP-2007 20:00:00 and if its value is 17-SEP-2007 22:40:00, then it be updated as 21:40:00

In other terms need to reduce the hour field value by 1 for all rows in the table.

Please advise. I am using Oracle 9i. Thank you very much. Received on Mon Sep 17 2007 - 00:02:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US