Not Just Another Programming and Multimedia Blog: SQL Date time

Showing posts with label SQL Date time. Show all posts

Showing posts with label SQL Date time. 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)