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
