Chris Payne wrote:
Could anyone show me an example of how to do this? So to take 2001-07-05
and add 3 days to it?
To use SQL to do this:
> SELECT FROM_DAYS((TO_DAYS('2001-07-05') + 3));
The TO_DAYS and FROM_DAYS are nice functions to use when you are
fildling with dates as numbers (i.e. doing a
ing usable.
HTH,
Rich
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 2:39 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Urgent DATA help needed
Hi there everyone,
My client suddenly dropped on me that they need to be able to search by
dat
Hi there everyone,
My client suddenly dropped on me that they need to be able to search by
date, IE: the past 1 day, 3 days, 5 days or 7 days. In the DB, the date
format is: 2001-07-05 (For example) but I have no clue how to count the days
in between to know how many days I am counting. Say t