Monday, August 5, 2013

how to get yesterday's date in sql server

To get yesterday's date in sql server

SELECT DATEADD(DAY,-1,GETDATE()) 'Yesterday'

No comments:

Post a Comment