FUDforum: comp.lang.php » MySQL date time current time diffenece

Home » Imported messages » comp.lang.php » MySQL date time current time diffenece

Show: Today's Messages :: Polls :: Message Navigator

Re: MySQL date time current time diffenece [message #175204 is a reply to message #175188]

Mon, 22 August 2011 10:03

Denis McMahon
Messages: 634
Registered: September 2010

Karma:

Senior Member

On Sun, 21 Aug 2011 09:42:41 -0400, j wrote:

> Can I count on (more or less) the MySQL time/time zone to be the same as
> that PHP uses?

I'd expect that on a competently administered mysql server, the date and
time functions would always be in a consistent timezone, but given that
the mysql server could be in a different continent to the system that php
is running on, I wouldn't assume that they will always be in the same
timezone.

If you need to do a lot of tz sensitive work, it *might* be more robust
to use php date and time functions, setting the appropriate php timezone,
and store and read the values as UTC integer seconds based on your
preferred epoch.

Rgds

Denis McMahon

Report message to a moderator

[Message index]

		MySQL date time current time diffenece By: j on Sun, 21 August 2011 13:42
		Re: MySQL date time current time diffenece By: Jerry Stuckle on Sun, 21 August 2011 14:15
		Re: MySQL date time current time diffenece By: Denis McMahon on Mon, 22 August 2011 10:03
		Re: MySQL date time current time diffenece By: Jonathan Stein on Mon, 22 August 2011 12:06

Previous Topic:	Webhosting, Domain Name, Data Center Cyprus, Hosting Services
Next Topic:	Roll SQL name value query into two-dimensional array

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:52:44 GMT 2024

Total time taken to generate the page: 0.04037 seconds