SQL

what is datetime in sql server

The DATETIME format in SQL servers is below:
YYYY-MM-DD hh:mm:ss
Below is an example:
2019-08-20

YYYY-MM-DD hh:mm:ss<--> 2019-08-20 

sql server datetime

DECLARE @date date = '12-21-16';  
DECLARE @datetime datetime = @date;  
  
SELECT @datetime AS '@datetime', @date AS '@date';  
  
--Result  
--@datetime               @date  
------------------------- ----------  
--2016-12-21 00:00:00.000 2016-12-21