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
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
---
StartTimeequivalent with the time format
1201561200 -> 2008-01-28 15:00:00
120159 -> 2008-01-28 23:00:00
120159
0:00:00
-Clark
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, December 19, 2007 10:09:42 AM
Subject: Re: [sqlite] How to truncate the hour
Hi P
Sorry for the confusion!
Current my hourAppAcclTable is store the following
Joanne Pham wrote:
> Hi P
> Sorry for the confusion!
> Current my hourAppAcclTable is store the following
> 1, 1198990800
> 2, 1198998000
> which is 2007-12-29 21:00:00 and 2007-12-29 23:00:00 if I used the datetime
> function to show the time format.
> What I want is to store
2007 9:49:43 AM
Subject: Re: [sqlite] How to truncate the hour
On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi,
> strftime doesn't work for me. I appreciate if you can help me on this.
>
> My hourlyAppAcclTable
> row1 - 1, 1198990800 -- (which is 12-29-2
qlite.org/cvstrac/wiki?p=DateAndTimeFunctions carefully.
Most of your questions will be answered there.
>
>
>
> - Original Message
> From: P Kishor <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, December 19, 2007 9:28:22 AM
> Subject: R
7 9:22:39 AM
Subject: [sqlite] How to truncate the hour
Hi All,
I have the table as defined below:
hourlyAppAcclTable ( appid INTEGER,
startTime INTEGER -- is number of seconds
in GMT time in the integer
.
)
the values in this
ber 19, 2007 9:28:22 AM
Subject: Re: [sqlite] How to truncate the hour
On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have the table as defined below:
> hourlyAppAcclTable ( appid INTEGER,
> startTime INTEGER -- is number o
On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have the table as defined below:
> hourlyAppAcclTable ( appid INTEGER,
> startTime INTEGER -- is number of seconds in
> GMT time in the integer
> .
> )
>
> the values
Hi All,
I have the table as defined below:
hourlyAppAcclTable ( appid INTEGER,
startTime INTEGER -- is number of seconds in GMT
time in the integer
.
)
the values in this table is :
row1 - 1, 1198990800
row 2 - 2,
15 matches
Mail list logo