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

8 votes297 views1 answer
Racle create auto increment column
SQL
2 votes252 views1 answer
Match in sql server
SQL
1 vote282 views1 answer
Import mysql dump database command line linux
SQL
0 vote274 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote268 views1 answer
Use where instead of join
SQL
4 votes274 views1 answer
Wildcard in sql
SQL
0 vote260 views1 answer
Select max salary from each department in sql
SQL
0 vote281 views4 answers
Mysql count table rows
SQL
0 vote283 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
4 votes274 views1 answer
Change nls_date_format
SQL