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 vote95 views1 answer
Psql lst trigger
SQL
0 vote114 views1 answer
Sql combine results from two tables
SQL
0 vote142 views1 answer
Postgresql find biggest table
SQL
1 vote110 views1 answer
Error code 1292 mysql workbench
SQL
0 vote123 views1 answer
Check constraint is violated
SQL
2 votes140 views1 answer
Oracle insert or update
SQL
13 votes121 views4 answers
Command line mysql import
SQL
4 votes105 views1 answer
Mysql not equal
SQL
1 vote111 views2 answers
Oracle list partitioned tables
SQL
2 votes112 views2 answers
How to run postgresql in linux
SQL