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

3 votes266 views2 answers
Having in mysql
SQL
4 votes285 views3 answers
Order by value mysql
SQL
-1 vote297 views1 answer
Spring boot mysql connection properties
SQL
5 votes301 views1 answer
Oracle list days between two dates
SQL
2 votes274 views1 answer
Sql ignore accents
SQL
0 vote262 views1 answer
Sql min
SQL
2 votes287 views1 answer
Change primary key sql
SQL
4 votes300 views4 answers
Start mysql
SQL
0 vote281 views1 answer
Pl sql search in all packages
SQL
2 votes297 views1 answer
Sql server case sensitive search
SQL