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 vote312 views1 answer
Example database query
SQL
0 vote290 views1 answer
Horizontal join sqlite
SQL
3 votes282 views3 answers
Sql current year
SQL
0 vote279 views1 answer
Postgresql inline table
SQL
0 vote278 views1 answer
How to remove default in mysql
SQL
11 votes281 views2 answers
Having clause
SQL
0 vote297 views1 answer
Renombrar tabla mysql
SQL
13 votes305 views1 answer
Select count of distinct values sql
SQL
0 vote300 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote296 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL