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 vote155 views1 answer
Test sql query
SQL
1 vote200 views1 answer
Postgresql where datetrunc month and year equal
SQL
14 votes154 views2 answers
Oracle export trigger ddl
SQL
0 vote146 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote146 views1 answer
Insert or update sql query
SQL
0 vote143 views1 answer
Sqldf change user
SQL
0 vote270 views1 answer
How to find the most occuring in SQL
SQL
2 votes141 views1 answer
Oracle index size calculation
SQL
1 vote150 views1 answer
Postgresql substring last
SQL
9 votes150 views3 answers
Oracle undo usage by session
SQL