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 vote329 views1 answer
Select if then postgresql
SQL
13 votes333 views2 answers
Sql count distinct group by
SQL
1 vote339 views1 answer
Mysql decimal allow negative values?
SQL
3 votes368 views1 answer
Laravel paginate raw sql
SQL
0 vote357 views1 answer
Providername system.data. mysql
SQL
3 votes341 views1 answer
Oracle drop user
SQL
1 vote338 views1 answer
Backup mysql data only
SQL
0 vote314 views1 answer
Go install mysql
SQL
0 vote352 views2 answers
Mysql calcular idade
SQL
2 votes329 views1 answer
Get first 2 letter in sql
SQL