Joanne Pham wrote:
Thank Ken,
But this is not what I want. I would like to truncate the hour.
So
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ? -> 2008-01-28 00:00:00
So I want to find out t2? which has no hour number.
So you just want the date (i.e. No time at all)? Seems like you have
two options. You can mod against 86400 (number of seconds in a day),
or you can just use the date(DateField) option, to only output the date.
sqlite> SELECT date('2007-01-19 12:54:32');
2007-01-19
sqlite> SELECT date('1201590000','unixepoch','localtime');
2008-01-28
Lots of good docs here:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
