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())

No comments:

Post a Comment

AZ-104

Microsoft Azure is huge and it has hundreds of services underneath its umbrella It's actually going to be quite difficult to comprehend ...