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

9 votes256 views6 answers
Check constraint in sql
SQL
8 votes227 views1 answer
Oracle find text in functions
SQL
0 vote246 views1 answer
Implicit inner join table alias
SQL
4 votes248 views1 answer
Mysql ip address data type
SQL
0 vote251 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote230 views1 answer
Oracle explain plan
SQL
0 vote257 views1 answer
Psotgres multiple values
SQL
0 vote233 views1 answer
Mysql add root password
SQL
0 vote284 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote255 views1 answer
Vbscript connect mssql
SQL