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. Thanks JP
----- Original Message ---- From: Ken <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, January 23, 2008 10:35:03 AM Subject: Re: [sqlite] How to truncate the hour fraction assuming your time is in seconds. try t1: 201561222 -> 2008-01-28 15:00:22 and you want t2: 1201561200 -> 2008-01-28 15:00:00 t1 = t2 - (t2 mod 3600) Joanne Pham <[EMAIL PROTECTED]> wrote: Hi All, I have a hour table which has the startTime are stored at GMT time. The startTime of this hour table has the values below: Hour table ----------- StartTime equivalent with the time format 1201561200 -> 2008-01-28 15:00:00 1201590000 -> 2008-01-28 23:00:00 1201590000 -> 2008-01-28 23:00:00 1201590000 -> 2008-01-28 23:00:00 I want to aggregate the data from hour table and store them in weekly table and startTime should not have any hour fraction. Is there any function to truncate all the hour fraction. Thanks, JP ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
