Typically, yes.

It is possible you don't have the time zone tables populated. "America/Bahia" works for me, so I suspect that is the case. The relevant manual page to load this data (assuming your server is running in a unix environment) is here:

If it is running in a Windows environment:


On 11/10/2013 04:22 PM PT, Ron Piggott wrote:

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?


Reply via email to