Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

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