Whats wrong with this less-than date query?

Viewed 80550
sqlite> SELECT * FROM RawResponseTimes WHERE CreationTime <= 2011-06-14 17:17:23;
Error: near ":17": syntax error

Everything appears to be fine but it isn't happy with the hour 17, what gives?

Using SQLite.

3 Answers
SELECT * FROM RawResponseTimes WHERE CreationTime <= CONVERT(DATETIME, '2011-06-14 17:17:23');
Related