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 vote212 views1 answer
Format the money fied with comma in international system using sql
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
7 votes262 views2 answers
Phpmyadmin change password
SQL
0 vote200 views1 answer
Sql query to get contact form 7 fields
SQL
5 votes191 views2 answers
Sql create tabel with primary key auto_increment code
SQL
-1 vote250 views1 answer
Add 10 to all numbers in a column sql
SQL
-1 vote205 views1 answer
Ms sql select datetime as date
SQL
2 votes195 views1 answer
Sqlite indexes
SQL
0 vote194 views1 answer
Wordpress sql change site url
SQL
0 vote193 views1 answer
Sql query to force the database to be drop
SQL