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 vote198 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote191 views1 answer
Oracle synonym procedure
SQL
-1 vote192 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote203 views1 answer
Find number of entries sql
SQL
0 vote199 views1 answer
Stored procedures example
SQL
3 votes230 views1 answer
Laravel paginate raw sql
SQL
0 vote242 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote260 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote200 views1 answer
Add many column to sap iq table
SQL
0 vote244 views1 answer
Drush run sql select
SQL