Re: date difference
| From: | Roel Mulder | Date: | Tue, 16 Oct 2001 20:09:40 +0000 |
| Subject: | Re: date difference | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13394@lists.php.net to get a copy of this message | ||
Hi,
MySQL is well documented http://www.mysql.com/doc/D/a/Date_and_time_functions.html and offers terrific means to calculate all the dates and times you fancy.
M.vr.gr.
Roel Mulder
At 15:56 16-10-2001 -0400, you wrote:
How can i convert the following sql command to work with mysql. select * from msg_operator_tbl where DATEDIFF(DAY,send_DATE, GETDATE()) > 7 Please help, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc.Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.nl