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

5 votes112 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
22 votes116 views3 answers
Year format in date mysql
SQL
8 votes104 views3 answers
Connect python to mysql
SQL
1 vote111 views1 answer
Oracle enable job
SQL
0 vote95 views1 answer
Mysql change default collation
SQL
0 vote113 views2 answers
SQL FROM
SQL
0 vote109 views2 answers
Mysql calcular idade
SQL
9 votes104 views4 answers
Mysql show table fields
SQL
0 vote98 views1 answer
Select from 3 tables one is empty
SQL
0 vote124 views1 answer
Ubuntu connect to mssql database
SQL