That makes a LOT more sense...misread "times" as "times" :-)
Sorry for any rant on my part.
Are all your times via your VB app?
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 9:15 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Subtract times hh:mm:ss
The word times in my previous post confused/misled you. These are execution
times, not values produced by SQL.
RBS
On Sunday, October 7, 2012, Black, Michael (IS) wrote:
> 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 <javascript:;> [
> sqlite-users-boun...@sqlite.org <javascript:;>] on behalf of Bart
> Smissaert [bart.smissa...@gmail.com <javascript:;>]
> 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<javascript:;>
> >
> 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 <javascript:;> [
> sqlite-users-boun...@sqlite.org <javascript:;>]
> > on behalf of Bart Smissaert [bart.smissa...@gmail.com <javascript:;>]
> > 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<javascript:;>
> >
> > 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 <javascript:;>
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org <javascript:;>
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org <javascript:;>
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org <javascript:;>
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org <javascript:;>
> 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
