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 votes133 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote124 views1 answer
Oracle sql add column auto generated value
SQL
0 vote122 views1 answer
Mysql add text to existing field
SQL
0 vote113 views1 answer
Count columns psql(PostreSQL)
SQL
4 votes68 views1 answer
Generate class from sql table c#
SQL
0 vote114 views1 answer
Tsql default value when no value returned by query
SQL
0 vote119 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
12 votes200 views2 answers
Find duplicates mysql column
SQL
4 votes123 views2 answers
Sql offset
SQL
5 votes139 views1 answer
Oracle asynchronous query
SQL