On 10 January 2011 07:42, Sven <tabaluga...@yahoo.de> wrote: > Dear SQLite users, > > I've created a Microsoft Access 2003 database with three complex queries > written in pure SQL language. The function of the database is to > document and calculate the daily work-time. . . . > and returns the following data '8.5'. While using the following query > code within SQLite: > > [code] > select time(end_time) - time(start_time) > [/code] > > I only get the following data returned: '8' (but not '8.5' as calculated > with SQL). > > So currently I don't know what to do next to solve my problem and > perhaps all the other users of this SQLite-users mailing list could help > me out.
http://www.sqlite.org/lang_datefunc.html select ( julianday( '16:30:00' ) * 24.0 ) - ( julianday( '08:00:00' ) * 24.0 ); > > best regards Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users