Shaun wrote:
"Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]

Shaun wrote:

Hi,

how can I check how many days are between two given dates?

Thanks for your help


There are many ways, it would help if you tell us what form are the dates in - timestamp, formated string, sql date column ...


Sorry,

The dates are retrieved from the database so are stored as YYYY-MM-DD
HH-MM-SS in MySQL

Thanks for your help


Let mysql do it:


SELECT TO_DAYS(date1) - TO_DAYS(date2) AS number_of_days ...

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to