Rachmat,
I also noted that one of your queries includes:
time_to_sec(timediff(akhir1.End, awal1.Begin))
I think time conversion routines are part of each database vendor's
implementation -- and not part of the sql standard, so you'll need to
convert to the time routines provided in sqlite or write your own
functions.
"Rachmat Febfauza" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> i have query that don't work in sqlite but in mysql work and make good
> result.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
