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 vote108 views1 answer
Mysql check table exists
SQL
2 votes109 views1 answer
Sqlite show table indexes
SQL
13 votes110 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote132 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
16 votes107 views6 answers
Mysql find and replace
SQL
0 vote68 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote109 views1 answer
Sql quary intervewi question
SQL
0 vote110 views1 answer
Oracle sql procedure return value
SQL
5 votes119 views1 answer
Sql table columns
SQL
16 votes113 views1 answer
Mssql int max value
SQL