Can any one tell me how to subtract 1 hour from Getdate()? I tried like this
for example modify_date=10:55:55 am and getdate=11:05:05 am
DATEDIFF(hh,MODIFY_DATE,GETDATE()) is giving result as 1 but i want difference 1 hr when getdate is 11:55:55 am ???
Any help is appriciated......
View Complete Post