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

Github Actions - CI/CD for React.js

 1. Install gh-pages npm package Command:  npm install gh-pages --save-dev 2. In package.json, add the homepage url "homepage": &q...