Afternoon all,
I have the following schema:
CREATE TABLE day
("id" INTEGER PRIMARY KEY,
"timestamp" DATETIME,
"value" REAL);
And the following sample data:
INSERT INTO day VALUES (NULL, "2012-01-01", "5.0");
INSERT INTO day VALUES (NULL, "2012-01-02", "6.0");
INSERT INTO day VALUES (NULL, "2012-01-03", "7.0");
INSERT INTO day VALUES (NULL, "2012-01-04", "5.0");
When I perform the following query I don't get the expected result:
SELECT * FROM day WHERE timestamp >= '2012-01-01 00:00:00';
2|2012-01-02|6.0
3|2012-01-03|7.0
4|2012-01-04|5.0
Why does this happen? Is this the sort of thing I should bother the SQLite
develops with (via bug report)?
*(I know I can do either of the following to get the expected result:*
*
*
*SELECT * FROM day WHERE timestamp >= date('2012-01-01 00:00:00');*
*SELECT * FROM day WHERE datetime(timestamp) >= '2012-01-01 00:00:00';)*
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
