Can I create a table with DATE datatype? Or just use text datatype with yyyy-mm-dd?
I can see that sorting will be easy with just text yyyy-mm-dd, But what about BETWEEN or > <? Or maybe strcmp() does the job? Thanks Daniel -----Original Message----- From: Chris Peachment [mailto:[EMAIL PROTECTED] Sent: Sunday, August 19, 2007 12:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Making SQL queries with date conditions? 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] ---------------------------------------------------------------------------- -
