|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
09-29-2006, 05:23 AM
|
|||
|
|||
SQL 92 answer.
Re: How do i create a query to extract all records within a given date. For instance beginning date and?
SELECT * FROM t WHERE d BETWEEN date('2002-01-01') AND date('2003-01-01');or using intervals:
SELECT * FROM t WHERE d BETWEEN date('2002-01-01') AND date('2002-01-01')+interval 10 month;    
|
|
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I format mySQL date? | Kut | SQL - Questions and Answers | 1 | 12-20-2006 05:20 PM |
| How to retrieve records which the date column should be 36 months older than the current date? | lowie | SQL - Questions and Answers | 1 | 08-21-2006 02:39 AM |
