Possible Duplicate:
MySQL CONVERT_TZ()
Does CONVERT_TZ take daylight saving into account?
For example:
CONVERT_TZ('2013-1-1 12:00:00', 'US/Pacific', 'UTC');
I got the correct result, but I am not sure how to test DST scenario.
Asked
Active
Viewed 285 times
0
Community
- 1
- 1
pixelfreak
- 17,714
- 12
- 90
- 109
-
Choose a date in the summer when DST is in effect? – Wiseguy Jan 04 '13 at 20:28
-
Heh, touché. Lemme try that :) – pixelfreak Jan 04 '13 at 20:35
-
According to [this answer](http://stackoverflow.com/a/3703030/679449) it does. – Kermit Jan 04 '13 at 20:38
-
Voted to close. Exact duplicate – pixelfreak Jan 04 '13 at 21:51