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

4 votes177 views3 answers
Mysql get column names from table
SQL
0 vote176 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote182 views1 answer
Mysql 3 months ago
SQL
0 vote180 views1 answer
Select * where id = 1,2,3
SQL
0 vote151 views1 answer
Apt install sql server
SQL
0 vote147 views1 answer
T-SQL Retry (deadlock)
SQL
1 vote140 views2 answers
How to check username in mysql command line
SQL
2 votes194 views3 answers
Mysql cheat sheet
SQL
2 votes184 views2 answers
Postgres change owner of schema
SQL
0 vote140 views1 answer
Replace multiple string in query sql
SQL