Update a MySQL field/Timezone
Posted: Thu Jun 24, 2010 10:45 am
I currently have a database that has a ID column and a Date column. The date column shows the date and time of the entry. There are approx 1 million records already in the database that have the incorrect timezone on the time. All new entries to the database have the time zone corrected. I am looking for a way to update/convert all the already existing date records to the correct timezone. The records that need to be updated are in the id range of 0-1000000, everything after 1000000 is corrected on insertion to the database table.
Example of my Table:
ID Column: 31615463
Date Column: 2010-06-24 13:59:06 | Note: I need this to change to -4 hours 2010-06-24 9:59:06
Your help is greatly appreciated.
Thanks
Example of my Table:
ID Column: 31615463
Date Column: 2010-06-24 13:59:06 | Note: I need this to change to -4 hours 2010-06-24 9:59:06
Your help is greatly appreciated.
Thanks