14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→specified time
m (→specified time) |
|||
| Line 71: | Line 71: | ||
** convert mysql timestamp to Taipei datetime <ref>[http://stackoverflow.com/questions/2934258/how-do-i-get-the-current-time-zone-of-mysql timezone - How do I get the current time zone of MySQL? - Stack Overflow]</ref> | ** convert mysql timestamp to Taipei datetime <ref>[http://stackoverflow.com/questions/2934258/how-do-i-get-the-current-time-zone-of-mysql timezone - How do I get the current time zone of MySQL? - Stack Overflow]</ref> | ||
<pre> | <pre> | ||
/* detect server timezone automatically */ | |||
SELECT convert_tz( | SELECT convert_tz( | ||
FROM_UNIXTIME( `column_of_timestamp` , '%Y-%m-%d %H:%i:%S' ), | FROM_UNIXTIME( `column_of_timestamp` , '%Y-%m-%d %H:%i:%S' ), | ||
| Line 77: | Line 78: | ||
TIME_TO_SEC(timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00')))/3600), ':00') | TIME_TO_SEC(timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00')))/3600), ':00') | ||
, '+08:00') | , '+08:00') | ||
FROM `table` | |||
/* If you already know the server timezone ex: -05:00 */ | |||
SELECT convert_tz( | |||
FROM_UNIXTIME( `column_of_timestamp` , '%Y-%m-%d %H:%i:%S' ), '-05:00', '+08:00') | |||
FROM `table` | FROM `table` | ||
</pre> | </pre> | ||