[sqlite] datetime modifier for localtime

[Derrell . Lipman]

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]

Re: [sqlite] datetime modifier for localtime

[Derrell . Lipman]

Kurt Welgehausen [EMAIL PROTECTED] writes:

 If I remember right, localtime and gmtime were not implemented
 in 2.8.8.  You need to upgrade.

Ah!  Well that would certainly explain it.  Thanks!

Derrell

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]