SIVA

SIVA

  • NA
  • 742
  • 700.3k

How to compare whether two timings are equal or not in SQL Server

Apr 6 2012 9:51 AM
Dear All,

I need to know how to compare Two timings in SQL Server

Here,

User will pass the @StatusTime as parameter for my Procedure

& i ll get the current time from my local system as follows.

Declare @CurrentTime datetime

set @CurrentTime=GetDate()

Now i need to compare these two?

Thanks in Advance


Answers (2)