Re: Calculating Past Dates In A Different Time Zone
| From: | Ron Piggott | Date: | Mon, 11 Nov 2013 00:22:04 +0000 |
| Subject: | Re: Calculating Past Dates In A Different Time Zone | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48832@lists.php.net to get a copy of this message | ||
A suggestion I was given is to use the mySQL "CONVERT_TZ" command with the PHP time zone names. But when I do:
SELECT CONVERT_TZ(
journal_entry.occurance_date , 'GMT', 'America/Bahia' ) FROM journal_entry
I am receiving "NULL" as the resulting date. Does mySQL accept PHP time zone names?
Ron