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

Reply via email to