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

Reply via email to