At 14:05 -0400 4/18/03, Verdon Vaillancourt wrote:
>Assuming I am selecting from a table where I have a field called
>`creation_date` with values in the format `YYYY-MM-DD`, should not the
>following query return only rows with creation dates that fall between the
Presumably, yes. But is creation_date defined as a DATE type, or something
Technically, I'd expect your query to result in an error, because 'table'
in single quotes isn't legal for specifying a table name.
>SELECT * FROM 'table' WHERE ((creation_date >= '2003-04-14') AND
>(creation_date <= '2003-04-18'))
>I have tried the above query and it seems to be returning all rows, not just
>those within the range.