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 vote199 views1 answer
Mysql select another database
SQL
0 vote197 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote198 views1 answer
Update and replace mysql
SQL
2 votes222 views2 answers
Create empty table from existing table
SQL
0 vote193 views1 answer
Import mysql'
SQL
3 votes216 views2 answers
Oracle apex view logs
SQL
11 votes199 views2 answers
Safe mode off mysql
SQL
0 vote208 views1 answer
Oracle current timestamp insert statement
SQL
0 vote215 views1 answer
Mssql dockere
SQL
0 vote203 views1 answer
Sql server beginning of month
SQL