The Resource For PHP Developers

php-general | 2001032

Re: [PHP] Date difference From: Mark Maggelet (maggelet <email protected>)
Date: 03/31/01

Next message: Jon Jacob: "[PHP] Compiling under RH7"
Previous message: Jon Jacob: "Re: [PHP] Quick RegEx Question"
In reply to: ravi <email protected>: "[PHP] Date difference"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Sat, 31 Mar 2001 20:07:10 +0600, (ravi <email protected>) wrote:
>Dear Friends,
>
>I am accessing a MySQL database through PHP.
>
>I have to calculate the difference between todays date and the date
>obtained
>from MySQL database.

select to_days(curdate())-to_days(datefield) from table;

- Mark

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

Next message: Jon Jacob: "[PHP] Compiling under RH7"
Previous message: Jon Jacob: "Re: [PHP] Quick RegEx Question"
In reply to: ravi <email protected>: "[PHP] Date difference"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Find a programming school near you

php-general | 2001032