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 vote195 views3 answers
Mysql connection string
SQL
1 vote201 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
17 votes199 views6 answers
Sql select distinct
SQL
8 votes207 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote194 views1 answer
Oracle enable job
SQL
0 vote195 views1 answer
Sql server select furst day of current year
SQL
0 vote208 views1 answer
Compare field sql server
SQL
0 vote204 views1 answer
Oracle table privileges
SQL
1 vote212 views1 answer
Spark sql convert string to date
SQL
2 votes186 views1 answer
Mysql how to store lat,lng
SQL