Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by loch
-
SUBTRACTING two Sybase DATETIME values to get duration
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- loch
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
SUBTRACTING two Sybase DATETIME values to get duration
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...- loch
- Thread
- Replies: 2
- Forum: Sybase: Adaptive (SQL) Server
