Time - 2 hours (Convert GMT+9 into GMT+7)



I have a table, time (GMT +9) looks like this

11:25:00 AM
01:21:12 PM
03:12:00 PM

I need to convert them into 2 hours slower (GMT+7)

My Desired output will be:
9:25:00 am
11:21:12 am
01:12:00 pm

Please provide SQL for this, thanks a lot !

Allen Browne

To subtract 2 hours from every record in Table1:

UPDATE [Table1]
SET [MyDate] = DateAdd("h", -2, [MyDate]);

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question