MySQL Forums
Forum List  »  PHP

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,
Oracle Austria

Options: ReplyQuote

Written By
July 18, 2005 09:21AM
July 19, 2005 07:15AM
Re: Dates on php
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.