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

Similar codes

1 vote154 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote139 views1 answer
How to check xampp mysql password
SQL
1 vote142 views1 answer
Oracle sql create or replace view
SQL
5 votes136 views2 answers
Postgres update with if condition query
SQL
0 vote156 views1 answer
How to find sql server name
SQL
0 vote145 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
-1 vote130 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote126 views5 answers
Sql table intermédiaire
SQL
0 vote142 views1 answer
Populate db from command line postgres
SQL
0 vote131 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL