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 vote227 views1 answer
Sql string contains case sensitive
SQL
2 votes242 views1 answer
Db.relationship sqlalchemy flask
SQL
1 vote252 views1 answer
Postgres see sequence current state
SQL
0 vote217 views1 answer
How to reset AI in sql
SQL
6 votes251 views4 answers
Mysql group by date
SQL
0 vote217 views2 answers
MySQL top percent
SQL
1 vote215 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote249 views1 answer
Get initials name in sql
SQL
1 vote238 views2 answers
Check if word is in column sql
SQL
0 vote258 views1 answer
Mysql 3 months ago
SQL