Why don't you try it and see? Use the sqlite3 command line interpreter with the a sample database.
On Sun, 19 Aug 2007 13:28:20 +0200, Daniel Cohen Gindi wrote: >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] >---------------------------------------------------------------------------- >- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
