One of the new data types originally shipped with SQL Server 2008 is the “DATE” data type.
The DATE data type provides only the date without requiring from the database developers to extract the date from the datetime anymore.
To this end you can just get the date with a single line of code:
SELECT CAST (SYSDATETIME() as DATE) as [current_date]; GO
or
SELECT CAST(GETDATE() as DATE) as [current_date]; GO
Read Also:
- The TIME data type in SQL Server 2008
- The set identity_insert Command in SQL Server
- How to Import and Export Unstructured Data in SQL Server – FileTables
- How to Import and Export Unstructured Data in SQL Server – FILESTREAM
- How to Import and Export Unstructured Data in SQL Server – The IMAGE Datatype
- T-SQL Tip: Inserting Leading Characters to a String
- T-SQL Tip: Getting all the Records from all Tables in all User Databases
- … all SQL Server development articles
Featured Database Productivity Tools
Snippets Generator: Create and modify T-SQL snippets for use in SQL Management Studio, fast, easy and efficiently.
Dynamic SQL Generator: Convert static T-SQL code to dynamic and vice versa, easily and fast.
Subscribe to our newsletter and stay up to date!
Check out our latest software releases!
Check out Artemakis’s eBooks!
Rate this article: 
(1 votes, average: 5.00 out of 5)
Loading...
Reference: SQLNetHub.com (https://www.sqlnethub.com)
© SQLNetHub
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 20 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and {essentialDevTips.com}. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.