end_time contains an integer value returned by the C function time(NULL), thus a value in the "unixepoch" format. How do I retrieve the pretty-printed value of the localtime? As can be seen from the statements below, I can retrieve the 'unixepoch' datetime value but not a value converted to local time...??? (This is with 2.8.8)
sqlite> .nullvalue <null> sqlite> SELECT end_time FROM the_table LIMIT 1; 1073928428 sqlite> SELECT datetime(end_time, 'unixepoch') FROM the_table LIMIT 1; 2004-01-12 17:27:08 sqlite> SELECT datetime(end_time, 'localtime') FROM the_table LIMIT 1; <null> sqlite> SELECT datetime(end_time, 'unixepoch', 'localtime') FROM the_table LIMIT 1; <null> Thanks, Derrell --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
