Good morning,
I am having a problem extracting correct rows from the database based on date. Perhaps someone can help. My SQLite database was imported from an Access database where the dates (in Access) were stored as mm/dd/yyyy. My application is written in Java where I am using the DateFormat method to convert the date to mm/dd/yy. However when I do a select based on that date, for example "SELECT * FROM tblEventInfo WHERE fldDateBowled >= '01/01/08' it returns all the rows in the database. My database does not use the timestamp, so the 00:00:00 is inconsequential. Reading the documentation, I found that dates in SQLite are in 'yyyy/mm/dd/' format. Still, doing "SELECT * FROM tblEventInfo WHERE fldDateBowled >= '2008-01-01'" does not yield the results I expect. What do I need to do with the dates when I import the data from Access? Do I need to convert them to YYYY-MM-DD? Any assistance is appreciated. Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: <http://www.mybowlingdiary.com/> http://www.mybowlingdiary.com Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
