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 #175189 is a reply to message #175188]

Sun, 21 August 2011 14:15

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 8/21/2011 9:42 AM, j wrote:
> I have a timestamp in MySQL table. I want to compare that to the current
> time. I'll be using this code on different servers.
>
> I can do this:
>
> $mysql_datetime = '2011-08-19 14:00:35';
>
> $mysql_datetime_formatted = preg_replace('/\D/','',$mysql_datetime);
>
> $date_now = date("YmdHis");
>
> $diff = $date_now - $mysql_datetime_formatted;
>
> echo "$mysql_datetime_formatted - $date_now = $diff in seconds";
>
> Can I count on (more or less) the MySQL time/time zone to be the same as
> that PHP uses?
>
> More reliable or easier way?
>
> Jeff

Try asking in comp.databases.mysql - there are better ways to do it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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 01:34:27 GMT 2024

Total time taken to generate the page: 0.04350 seconds