Hi Jegan



Try something this:



UPDATE yourtable SET prod_date_offset = prod_date_offset - date('1 hour')



You can read all about date operations in the ingres manual.

Please check out "Date/Time Arithmetic" in the Ingres SQL Reference Guide
Chapter 4 (page 103)



Also please kindly note Ingres is spelt with one S.



Paul





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Jesudhason, Jegan
Sent: Sunday, 8 March 2009 9:17 AM
To: Info-Ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Required help in another 1 hour for day light savings
issue.
Importance: High



Hello Sir/Madam ,



I am supporting one application where the data is stored in INGRESS. I have
a one field "prod_date_offset" which has a data type as DATE but value is
show as "6 hrs" I wanted to decrease the value by 1 for that file and the
final result should be 5 hrs. please let me know how to do that . that's
would be more/ appropriate helpful for me if you make the reply in another
1 hour.



Please treat this is a high priority issue and let me .



Have a great day



Thanks

Jegan






_____





This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law. If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy. Thank you.





_____