Hello All,
I am inserting data into asset table as m/d/yyyy HH:MM:SS t format
Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('12/22/2009 12:01:00 AM')
Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('9/22/2009 12:01:00 AM')
but my select query failed : No record found
SELECT * FROM asset where WARRANTSTDATE BETWEEN '8/02/2009 12:01:00 AM'
AND '10/01/2009 12:01:00 AM'
Is there any settings for DateTime Query OR Specific DateTime format used
for SQLITE DB
Thanks
Ram
--
View this message in context:
http://old.nabble.com/Between-Query-failed-for-DATETIME-in-sqlite-tp26897635p26897635.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
