Not Just Another Programming and Multimedia Blog: SQL DateTime Functions

Showing posts with label SQL DateTime Functions. Show all posts

Showing posts with label SQL DateTime Functions. Show all posts

Monday, December 19, 2011

DateTime Functions

To get current date

SELECT GETDATE()

To get yesterday

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

Subscribe to: Posts (Atom)