MySQL GMT --> Local time
| From: | Jason | Date: | Thu, 17 Oct 2002 05:25:47 +0000 |
| Subject: | MySQL GMT --> Local time | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-120281@lists.php.net to get a copy of this message | ||
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