Results 1 to 2 of 2
Thread: CONVERT_TZ Query
Apr 7, 2011, 05:29 #1
- Join Date
- Dec 2008
- 0 Post(s)
- 0 Thread(s)
I am capturing data (server is utc -5) so example timestamp would be: 2011-03-25T22:25:55-05:00.
Now, that's all good and well when I return data like so: "SELECT * FROM `table` WHERE `timestamp` LIKE '2011-03-25'".
But what happens if I want to return data from a different timezone?
e.g UK would be 00:00 and not -05:00.
See where I'm going with this?
If only i could save a timestamp for each timezone, but that's overkill! there has to be a more realistic way!? apparently i could do it somehow with CONVERT_TZ in mysql?
Can anybody shed any light?