| List: | General Discussion | « Previous MessageNext Message » | |
| From: | ML | Date: | February 1 2010 3:13pm |
| Subject: | Re: Selecting Dates | ||
| View as plain text | |||
Jim, > Shouldn't it be: > SELECT * FROM orders WHERE order_date >= '2010-01-01' AND order_date <= > '2010-01-30' ORDER BY order_date; > > ? > > change the "=>" and repeat the column_name. Datetime should be datetime or > timestamp; Spot on. Thank you for the clarification, obviously a syntax mistake on my part. -ML
| Thread | ||
|---|---|---|
| • Selecting Dates | ML | 1 Feb |
| • Re: Selecting Dates | Lucky Wijaya | 1 Feb |
| • Re: Selecting Dates | Paul DuBois | 4 Feb |
| • Re: Selecting Dates | sureshkumarilu | 1 Feb |
| • Re: Selecting Dates | Jim Lyons | 1 Feb |
| • Re: Selecting Dates | ML | 1 Feb |
