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