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 |