Re: [PHP] MySQL GMT --> Local time

2002-10-17 Thread Jason
On Thu, 17 Oct 2002, 1LT John W. Holmes wrote: > > 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 woul

Re: [PHP] MySQL GMT --> Local time

2002-10-17 Thread 1LT John W. Holmes
> 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

RE: [PHP] MySQL GMT --> Local time

2002-10-16 Thread Jason
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:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 3:26 PM > To: php_gen > Subject: [PHP] MySQL GMT --> Local time > > > > My logg

RE: [PHP] MySQL GMT --> Local time

2002-10-16 Thread Smith, Benjamin
Local to the client or local to the server? -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] 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 w

Re: [PHP] MySQL GMT --> Local time

2002-10-16 Thread dwalker
Try something like: 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 RECIPIE