Showing posts with label Date Time Functions. Show all posts
Showing posts with label Date Time Functions. Show all posts

Monday, December 19, 2011

DateTime Functions


To get current date

SELECT GETDATE()

To get yesterday

SELECT DATEADD(d,-1,GETDATE())