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 vote165 views1 answer
How to install sql in anaconda
SQL
0 vote170 views1 answer
Python connect microsoft sql server
SQL
1 vote178 views1 answer
Mysql find most common value
SQL
7 votes191 views1 answer
Sql pagination oracle
SQL
0 vote179 views1 answer
How to find total working hour in sql
SQL
0 vote158 views1 answer
Stuff in sql server
SQL
2 votes162 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote177 views1 answer
How to check common records in 2 table
SQL
0 vote161 views1 answer
Find usage of table in sql server
SQL
0 vote176 views2 answers
How to install mssql on mac
SQL