.Net: GETDATE()

Showing posts with label GETDATE(). Show all posts

Showing posts with label GETDATE(). Show all posts

Friday, March 25, 2011

GETDATE() to get only date in sql

To get only the date from T-SQL GETDATE() function (excluding the time part)

Example Query:

Select * From Employee Where JoinDate = Convert(Date, GETDATE())

Subscribe to: Posts (Atom)