On 16/04/2009 2:17 PM, Igor Tandetnik wrote:
> "Joanne Pham" <joannekp...@yahoo.com>
> 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 midnight (of any day) when
> it's not a multiple of 24*60=1440. What epoch are you counting from?
> This:
>
> select datetime(20657220*60, 'unixepoch');
>
> produces 2009-04-11 07:00:00 for me.
>
> Normally, I'd expect something like "startTime / 1440 * 1440" to work
> (this simply rounds down to nearest multiple of 1440). But I guess I
> don't understand your time representation conventions.
Message headers:
Date: Wed, 15 Apr 2009 20:24:38 -0700 (PDT)
^^^^^
From: Joanne Pham <joannekp...@yahoo.com>
12 AM in (e.g.) San Francisco is 7 AM UTC
HTH,
John
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
