201478400', 'unixepoch');
2008-01-28 00:00:00
Proves the result is what you asked for.
Good luck!
-Clark
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, January 23, 2008 2:02:09 PM
Subject: Re: [sqlite] How to truncate the hour fract
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-users@sqlite.org
Sent: Wednesday, January 23, 2008 10:44:07 AM
Subject: Re: [sqlite] How to truncate the hour fraction
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 w
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)?
PROTECTED]>
To: sqlite-users@sqlite.org
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 =
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
6 matches
Mail list logo
