Thanks a ton Igor!
It worked. Your help is greatly appreciated.
Thanks,
JP
From: Igor Tandetnik
To: sqlite-users@sqlite.org
Sent: Thursday, April 16, 2009 4:52:28 AM
Subject: Re: [sqlite] Need help with the SQL statement.
"Joanne Pham"
wrote in me
"Joanne Pham"
wrote in message news:348376.69121...@web90302.mail.mud.yahoo.com
> 20657220 is number of minutes in GMT time zone.
> So we need to convert to second by 20657220 *60.
> select datetime(20657220*60, 'unixepoch','localtime' );
> will be 2009-04-11 00:00:00
In this case, this should wo
ik
To: sqlite-users@sqlite.org
Sent: Wednesday, April 15, 2009 9:17:09 PM
Subject: Re: [sqlite] Need help with the SQL statement.
"Joanne Pham"
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
> But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
> ma
On 16/04/2009 2:17 PM, Igor Tandetnik wrote:
> "Joanne Pham"
> wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
>> But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
>> may not be there in the dailyDataTable so min(startTime) won't work
>> in this case. Any idea Ig
"Joanne Pham"
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
> But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
> may not be there in the dailyDataTable so min(startTime) won't work
> in this case. Any idea Igor?
I don't quite see how 20657220 can represent mi
e.org
Sent: Wednesday, April 15, 2009 7:44:48 PM
Subject: Re: [sqlite] Need help with the SQL statement.
"Joanne Pham"
wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com
> Hi All,
> I have the following table(dailyDataTable) as defined below
> startTime INTEGER :
"Joanne Pham"
wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com
> Hi All,
> I have the following table(dailyDataTable) as defined below
> startTime INTEGER : number of minutes in GMT time
> appId INTEGER : application Id
> remoteId INTEGER : server id
> proxyCount INTEGER
> This tab
Hi All,
I have the following table(dailyDataTable) as defined below
startTime INTEGER : number of minutes in GMT time
appId INTEGER : application Id
remoteId INTEGER : server id
proxyCount INTEGER
This table can have up to 24 hours as below: (this table ca
8 matches
Mail list logo