RE: [PHP] Date query
| From: | John W. Holmes | Date: | Sun, 20 Apr 2003 16:58:42 +0000 |
| Subject: | RE: [PHP] Date query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144553@lists.php.net to get a copy of this message | ||
> I have two columns in my table in date format: Booking_Start_Date and
> Booking_End_Date.
>
> How can i find out how many days (if any) are betweent these tow
dates?
SELECT TO_DAYS(Booking_End_Date) - TO_DAYS(Booking_Start_Date) AS
Num_Days FROM table
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/