Not Just Another Programming and Multimedia Blog: DateTime

Showing posts with label DateTime. Show all posts

Showing posts with label DateTime. 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)