dates in select statement
| From: | Mihai Dumitrescu | Date: | Thu, 14 Dec 2000 16:47:32 +0000 |
| Subject: | dates in select statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30312@lists.php.net to get a copy of this message | ||
If you used a SQL database and your field I suppose that is named
"date_field".
First statement :"SELECT * FROM tbl_name WHERE
(date_filed<data2) and (date_field>data1);"
I suppose you use the data format "YYYY-MM-DD"
SELECT * FROM tbl_name WHERE (date_field<YYYY-MM-31) AND
(dae_field>YYYY-MM-01);
for the last statement :"........(date_field<YYYY-12-31) AND
(date_field>YYYY-01-01)"
Mihai