You expect the readers on this list to go find your old post and then look at
what you're NOT doing now? You asked how to compute time, we showed you, and
now you are apparently doing it incorrectly.
You need to provide enough info in your current post for people to duplicate
your current problem and want to help you.
You showed you are getting 3 different answers...presumably from the same
record...but you don't show us the fields you are computing it from, nor the
code which does it.
Come to think of of it....there was no question in your last post either.
So help us help you.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Bart Smissaert [bart.smissa...@gmail.com]
Sent: Sunday, October 07, 2012 8:18 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Subtract times hh:mm:ss
There are no different answers and I think all the information is in the
first post.
RBS
On Oct 7, 2012 1:21 PM, "Black, Michael (IS)" <michael.bla...@ngc.com>
wrote:
> You haven't provided enough info for anybody to tell what's going on.
>
> What data are you substracting? Can you provide an sql dump of the data
> that gets different answers and your code?
>
> You can' even get fractional seconds from those statements as the time
> format only supports hr/min/sec
>
>
>
> Michael D. Black
> Senior Scientist
> Advanced Analytics Directorate
> Advanced GEOINT Solutions Operating Unit
> Northrop Grumman Information Systems
>
> ________________________________________
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of Bart Smissaert [bart.smissa...@gmail.com]
> Sent: Saturday, October 06, 2012 12:38 PM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] Subtract times hh:mm:ss
>
> Times I get (65000 records, subtracting 2 fields defined as text in
> the same table)
> gives me following times:
> method with julianday 0.4 secs
> method with unixepoch 0.6 secs
> using ctime etc. via VB wrapper 1.2 secs
>
> RBS
>
> On Tue, Oct 2, 2012 at 7:39 PM, Igor Tandetnik <itandet...@mvps.org>
> wrote:
> > On 10/2/2012 1:00 PM, Bart Smissaert wrote:
> >>
> >> Is there a way to subtract times in the text format hh:mm:ss
> >> and return the difference in the same format?
> >
> >
> > select time(julianday('03:22:11') - julianday('01:22:33') - .5);
> > select time(strftime('%s', '03:22:11') - strftime('%s', '01:22:33'),
> > 'unixepoch');
> >
> > Both of these return '01:59:38'.
> > --
> > Igor Tandetnik
> >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
