On Mar 17, 2005, at 2:24 PM, Kurt Welgehausen wrote:
Yes, I know it supports it without the "T" ...
sqlite> select strftime("%Y-%m-%dT%H:%M:%S", 'now', 'localtime'); strftime("%Y-%m-%dT%H:%M:%S", 'now', 'localtime') ------------------------------------------------- 2005-03-17T16:21:30
No:
sqlite> select strftime("%m", '2005-03-17T16:21:30'); strftime("%m", '2005-03-17T16:21:30') -------------------------------------
You see, I'm storing records with the T in the date string, but SQLite's strftime() can't parse the date string with the T.
Regards,
David