No trouble, it was somewhat confusing. Yes, all done through the VB wrapper.
RBS
On Oct 7, 2012 7:38 PM, "Black, Michael (IS)" <michael.bla...@ngc.com>
wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
