Joanne Pham wrote:
Any help for this question please!
I would like to convert from t1 to t2.
and my table is store t2.
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ? -> 2008-01-28 00:00:00
I think your numbers got cutoff... you mean 1201561222 right? Anyway
try this:
sqlite> SELECT date(1201561222 - (1201561222 %
86400),'unixepoch','localtime');
2008-01-27
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------