Re: 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 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php