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 vote181 views1 answer
Select from column mysql
SQL
1 vote138 views1 answer
Mssql string length
SQL
1 vote181 views1 answer
Mysql view command
SQL
0 vote302 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote217 views1 answer
Sql grant select only
SQL
0 vote273 views1 answer
Trigger
SQL
11 votes235 views2 answers
Having keyword sql
SQL
0 vote191 views1 answer
Flask sqlalchemy remove duplicates
SQL
36 votes195 views6 answers
Rename table sql
SQL
11 votes211 views2 answers
Set default column value sql
SQL