Hello,
According to the Date And Time Functions documentation[1], datetime(...)
can be expressed as strftime('%Y-%m-%d %H:%M:%S', ...), however, that
doesn't seem to be the case here:
SQLite version 3.8.7 2014-09-20 00:35:05
Enter ".help" for usage hints.
sqlite> SELECT datetime(1);
-4713-11-25 12:00:00
sqlite> SELECT strftime('%Y-%m-%d %H:%M:%S',1);
-471-11-25 12:00:00
Is this perhaps undefined behavior because it does say %Y has a range of
0000--9999?
[1]. https://www.sqlite.org/lang_datefunc.html
Thanks,
Andy
--
TAI64 timestamp: 400000005425a54a
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
