On Tue Jul 23, 2019 at 04:41:59PM +0200, Andreas Kretzer wrote:
> Am 23.07.2019 um 16:22 schrieb Steve Leonard:
> >
> > 4)I have tried several combinations of creating a new field
> > of type numeric, blob, real, and integer and then tried to update
If you want to work with date *strings* of the form 'yyyy-mm-dd' you
probably want to use TEXT.
> > 3) I want to select all records where myfdt is between 11/05/2011 and
> > 12/30/2011.... have had no success
> > Could someone please post the correct sql statement to do this?
> >
> > queries like this give no results:
> > select * from mytable
> > where myfdt > '11/06/2011'
> > and myfdt < '04/13/2018'
If you have modified your data to be yyyy-mm-dd then your queries
should also be in that format:
SELECT * FROM mytable
WHERE myfdt > '2011-11-06'
AND myfdt < '2018-04-13'
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
