Try something like:
<?php echo
oMySQLTimeStamp( $GetCustHistInfo->Fields("AccountActivationDate"), 'l, F jS
Y H:i:s') ?>
THIS E-MAIL MESSAGE AND ALL ATTACHMENTS TRANSMITTED HEREWITH ARE TRADE
SECRET AND/OR CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE VIEWING AND
USE OF ADDRESSEE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED
RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY REVIEW, USE, COMMUNICATION,
DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS PROHIBITED.
IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY THE SENDER
IMMEDIATELY BY TELEPHONE OR ELECTRONIC MAIL, AND DELETE THIS MESSAGE AND
ALL COPIES AND BACKUPS THEREOF. THANK YOU FOR YOUR COOPERATION.
-----Original Message-----
From: Jason <[EMAIL PROTECTED]>
To: php_gen <[EMAIL PROTECTED]>
Date: Thursday, October 17, 2002 12:26 AM
Subject: [PHP] MySQL GMT --> Local time
>
>My logging application is feeding a MySQL database with data records
>that are time stamped with GMT time. I would like to query the database
>for records matching local time(eg. all records created on oct
>17,2002 local time). I would prefer if the records could be formated
>in local time when returned from MySQL. What is the best way to do this.
>
>Jason
>
>
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
