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 vote373 views1 answer
How to find total working hour in sql
SQL
0 vote384 views1 answer
Sql multiple into
SQL
0 vote346 views1 answer
How to create an SQL save method in ruby
SQL
2 votes340 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote395 views1 answer
Change date format in oracle query
SQL
0 vote304 views1 answer
Import csv to mysql
SQL
0 vote348 views2 answers
Transaction php
SQL
2 votes336 views1 answer
Postgresql add entry to table
SQL
0 vote368 views1 answer
Postgres change the name of schema
SQL
0 vote324 views1 answer
How to count null values in sql
SQL