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 vote129 views1 answer
Uncomment listen_address=localhost
SQL
0 vote141 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote136 views1 answer
Duplicate value unique constraint mysql error
SQL
2 votes137 views1 answer
Metasploit start postgresql
SQL
0 vote150 views1 answer
How to get button for every record from mysql
SQL
0 vote119 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote128 views1 answer
Sort by last two number sql
SQL
0 vote131 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
-2 votes139 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote157 views1 answer
Mysql where sum > 0
SQL