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 vote132 views1 answer
Mysql remove tabs from string
SQL
0 vote138 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote151 views1 answer
Sql last 3 rows
SQL
1 vote139 views1 answer
Oracle update with sequence
SQL
0 vote144 views1 answer
Sql server beginning of month
SQL
0 vote121 views1 answer
Insert thai language sql server
SQL
2 votes139 views2 answers
Postgresql get table names
SQL
0 vote183 views1 answer
Example database query
SQL
0 vote122 views1 answer
Select value from previous row in postgresql
SQL
6 votes170 views1 answer
How to get the size of the database in postgresql
SQL