Re: [Info-Ingres] Required help in another 1 hour for day lightsavings issue.

#1

update <tablename> set prod_date_offset = prod_date_offset - '1 hr'
should work

--cnemelka

On Sat, Mar 7, 2009 at 4:19 PM, <Jegan.Jesudhason (AT) cognizant (DOT) com> wrote:

Quote:

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 .

Thanks

J Jesudhason
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [Info-Ingres] Required help in another 1 hour for day lightsavings issue.

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Required help in another 1 hour for day lightsavings issue. - 03-08-2009 , 11:20 PM