SUBTRACTING two Sybase DATETIME values to get duration

[loch]

Hi. Can someone assist a newbie in calculating the length of time (in days) from one date value to another?

For example, I have START_DATE and END_DATE values (both DATETIME datatypes) in a temp table. I want to update the table with a DURATION value. I tried the following:

UPDATE #TEMP1
SET DURATION = (END_DATE - START_DATE)
FROM #TEMP1
WHERE END_DATE IS NOT NULL

However, I'm getting error "Invalid operator for datatype op: SUBTRACT type: DATETIME." I've tried converting the datatype without much luck either.

Much appreciate the feedback.

 

[loch]

never mind, i found the correct syntax.

UPDATE #TEMP
SET A.DURATION = DATEDIFF(DD, END_DATE, START_DATE)
FROM #TEMP A
WHERE A.END_DATE IS NOT NULL

 

[dickiebird]

Great - Always better to find out for yourself !
;-) Dickie Bird
Honi soit qui mal y pense