RE: [PHP] MySQL GMT --> Local time
| From: | Jason | Date: | Thu, 17 Oct 2002 06:10:55 +0000 |
| Subject: | RE: [PHP] MySQL GMT --> Local time | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120287@lists.php.net to get a copy of this message | ||
To the server.
On Thu, 17 Oct 2002, Smith, Benjamin wrote:
> Local to the client or local to the server?
>
> -----Original Message-----
> From: Jason [mailto:jason@frontiertech.ca]
> Sent: Thursday, 17 October 2002 3:26 PM
> To: php_gen
> 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
>
>