Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 time difference

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-26 : 09:12:13
Anil writes "I would like to know how to find the time difference..."

nr
SQLTeam MVY

12543 Posts

Posted - 2002-02-26 : 09:24:00
Look at datediff in bol

can also just select @date1 - @date2 as dates are held as decimal numbers since 1 jan 1900 with the integer part being the date and the decimal the time.

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -