Re: [sqlite] Need help with the SQL statement.

2009-04-16 Thread Joanne Pham
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

Re: [sqlite] Need help with the SQL statement.

2009-04-16 Thread Igor Tandetnik
"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

Re: [sqlite] Need help with the SQL statement.

2009-04-15 Thread Joanne Pham
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

Re: [sqlite] Need help with the SQL statement.

2009-04-15 Thread John Machin
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

Re: [sqlite] Need help with the SQL statement.

2009-04-15 Thread Igor Tandetnik
"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

Re: [sqlite] Need help with the SQL statement.

2009-04-15 Thread Joanne Pham
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 :

Re: [sqlite] Need help with the SQL statement.

2009-04-15 Thread Igor Tandetnik
"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

[sqlite] Need help with the SQL statement.

2009-04-15 Thread Joanne Pham
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