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 vote175 views2 answers
Csv into data postgres
SQL
0 vote193 views1 answer
Can sqldatareader be null
SQL
2 votes187 views1 answer
Sql server check for value in multiple columns
SQL
0 vote172 views1 answer
Postgresql create user roles
SQL
6 votes238 views2 answers
How to get yesterday date in mysql
SQL
0 vote282 views1 answer
Oracle sql all days except weekends
SQL
0 vote174 views1 answer
Select from column mysql
SQL
0 vote183 views1 answer
Write sql query to show the details start from digit
SQL
0 vote183 views1 answer
Mysql group by derived column
SQL
0 vote226 views1 answer
Sql from null to not null
SQL