At 14:05 -0400 4/18/03, Verdon Vaillancourt wrote:
>Hi :)
>
>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
>specified range?
Presumably, yes. But is creation_date defined as a DATE type, or something
else?
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.
>
>?? TIA,
>Verdon
--
Paul DuBois
http://www.kitebird.com/
sql, query
