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

React.js multiselect dropdown using Material UI

React Multi-Select Country → State → City Dropdown (Service Based) React Material UI Multi-Select Dropdown (Count...