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

A

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 !
 
A

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

Similar Threads

Time Zone Conversion Table 1
Total Minutes Worked Within IVR Timing 1
Calculate hours worked outside regular shift using date/time and iff condition 3
How to build subquery on aggregate query 0
separating date and time 5
Grouping/Deleting Dates/Times (HELP ANYONE!) 2
Query Help 0
15 minute data to daily data 1

Top