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