Use the ISO date format yyyymmdd or yyyy-mm-dd and your sort and search problems disappear.
On Sun, 19 Aug 2007 12:16:41 +0200, Daniel Cohen Gindi wrote: >Hi guys! > >Is there any way to make SQL queries, with the WHERE clause containing >dates? I mean [WHERE col > 05/12/2007] or such? >It just that I have noticed that there's no DATE datatype. >If there's no way, is it easy to override the text comparing operators (<=, >>=, <, >) ? > >Thanks a lot! ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
