MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Dates on php
Posted by: Markus Popp
Date: July 19, 2005 03:06PM

If I get your problem right, you can do it with a single query:

select unix_timestamp(now()) - unix_timestamp(your_datetime_field) as difference_in_seconds from your_table;

--
Markus Popp, Web Developer, mysql.com
Oracle Austria

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Dates on php
Laurent Foubert
July 18, 2005 09:21AM
Re: Dates on php
Slava Divxak
July 19, 2005 07:15AM
Re: Dates on php
Markus Popp
July 19, 2005 03:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.