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
