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

[ali]

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]);