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

0 vote269 views1 answer
Show table details postgresql
SQL
0 vote268 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote281 views1 answer
How do you insert boolean to postgresql
SQL
5 votes275 views6 answers
Sql foreign key
SQL
0 vote215 views1 answer
Mysql insert with foreign key
SQL
0 vote258 views1 answer
Where in clause tsql
SQL
1 vote266 views1 answer
Mysql query bulk insert
SQL
-2 votes253 views3 answers
Sqlite reset autoincrement
SQL
3 votes261 views1 answer
Oracle revoke grant
SQL
0 vote270 views2 answers
Laravel: customize or extend notifications - database model
SQL