TIMESTAMPDIFF

Deepatinfy · New User Joined: 06 Jun 2005 Posts: 7

Hi All,

Can you correct this query for me?

SELECT DF1,TIMESTAMPDIFF(16,DF1) AS DIFF, DAYS('1996-03-01-00.00.01') - DAYS('1995-03-01-00.00.00') AS DAYS
FROM (
SELECT TS1,TS2,CHAR(TS1 - TS2) AS DF1
FROM (
SELECT TIMESTAMP('1996-03-01-00.00.01') AS TS1, TIMESTAMP('1995-03-01-00.00.00') AS TS2
FROM SYSIBM.SYSDUMMY1
)AS TEMP2
)AS TEMP3

The error that shows up is,

QUERY MESSAGES:
NO FUNCTION BY THE NAME TIMESTAMPDIFF HAVING COMPATIBLE ARGUMENTS WAS FOUND

Thanks,
Deepesh

somasundaran_k · Active User Joined: 03 Jun 2003 Posts: 134

Deepatinfy

TIMESTAMPDIFF is used to find out the difference between two timestamps.But in your query you have specified only one timestamp. It should be something like TIMESTAMPDIFF(16,(DF1-DF2)) where DF1 and DF2 are the two timestamps that you want find out the difference in days.

hth
-Som