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

Deploying ASP.NET MVC app on Ubuntu

.NET 10 MVC Deployment on Ubuntu with Nginx, systemd, PostgreSQL & Cloudflare Architecture: Browser → Cloudflare (Flexible SSL)...