date comparisons in sql
Posted by jill (jill), 20 November 2002I have got a field in a mysql table with datatype date. I can call it up and print it out - it comes out in the format 2002-10-1. However I cannot get a comparison to work in an sql statement eg
select * from erfn where LesDiv = 1 and PublishDate > '2002-10-1'
gives the error message
Warning: Supplied argument is not a valid MySQL result resource
I am using it in a php page.
I have tried other formats like '10/1/2002'
Posted by admin (Graham Ellis), 21 November 2002Have you tried "01" rather than "1" for the day? This may seem the ultipmate of picky-ness, but all the format descriptiors do talk about DD rather than just D.
I do also question whether the error is generated by your select statement at all, or if it's caused by a variable name being mis-spelled; this is the sort of
error message I would expect if I wrote
Posted by jill (jill), 9 December 2002Sorry not to reply sooner - it was indeed a mistyped variable name. Thanks.
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: email@example.com • WEB: http://www.wellho.net • SKYPE: wellho