Dmitri Pissarenko wrote:
Hello!
> SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,
> APP.MyTable.startTime, APP.MyTable.endTime)}
> FROM APP.MyTable
> WHERE APP.MyTable IS NOT NULL
Should this be
WHERE APP.MyTable.startTime IS NOT NULL
?
Thanks for the hint!
Now I'm getti
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.
Hello!
> SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,
> APP.MyTable.startTime, APP.MyTable.endTime)}
> FROM APP.MyTable
> WHERE APP.MyTable IS NOT NULL
Should this be
WHERE APP.MyTable.startTime IS NOT NULL
?
Thanks for the hint!
Now I'm getting this exception:
SQL St
Dmitri Pissarenko wrote:
Hello!
I need to calculate the difference between two timestamp fields in
seconds. I tried this query:
SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,
APP.MyTable.startTime, APP.MyTable.endTime)}
FROM APP.MyTable
WHERE APP.MyTable IS NOT NULL
Hello!
I need to calculate the difference between two timestamp fields in
seconds. I tried this query:
SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,
APP.MyTable.startTime, APP.MyTable.endTime)}
FROM APP.MyTable
WHERE APP.MyTable IS NOT NULL
but it doesn't work
