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 vote291 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
8 votes331 views1 answer
Mysql dump restore
SQL
1 vote280 views1 answer
Postgres check for foreign key
SQL
0 vote293 views3 answers
Join
SQL
0 vote277 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
8 votes299 views1 answer
Oracle search text in all packages
SQL
1 vote282 views2 answers
Postgres cast as decimal
SQL
1 vote265 views1 answer
Using SQL in rails migration
SQL
0 vote267 views1 answer
Json_remove mysql
SQL
23 votes300 views3 answers
Sql where contains part of string
SQL