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 vote215 views1 answer
Mysql use password error
SQL
17 votes228 views6 answers
MySQL ORDER BY
SQL
0 vote214 views1 answer
Incorrect string value: mysql
SQL
0 vote228 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote208 views1 answer
What does the -p flag do in mysql cli
SQL
31 votes219 views4 answers
Mysql grant execute
SQL
1 vote245 views1 answer
Mariadb get column names from table
SQL
3 votes234 views1 answer
Async await mysql nodejs
SQL
0 vote204 views1 answer
Access refused mysql xampp server
SQL
0 vote232 views1 answer
How much space does sql server take per row
SQL