Return the date part only from a datetime

SQL Server

 

Famous database from Microsoft. Skyvia requires the server to be available from Internet.

How to return the date part only from a SQL Server datetime datatype

Query Text

use AdventureWorks;
SELECT
  CONCAT(FirstName, ' ', MiddleName, ' ', LastName),
  CONVERT(date, ModifiedDate)
FROM 
  Person.Person
  

Open Query