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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: loch
  • Order by date
  1. 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
  2. loch

    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...

Part and Inventory Search

Back
Top