Hello! I found the error. This query is correct (SQL_TSI_SECOND instead of SQL_TSI_FRAC_SECOND):
> > SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_SECOND,
> > APP.MyTable.startTime, APP.MyTable.endTime)}
> > FROM APP.MyTable
> > WHERE APP.MyTable.startTime IS NOT NULL
Thanks again. Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/
