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 vote207 views1 answer
Modifier une valeur sql
SQL
2 votes158 views2 answers
Mysql get time from datetime
SQL
2 votes175 views1 answer
Add default sql server
SQL
11 votes160 views4 answers
Query DISTINCT
SQL
0 vote164 views2 answers
Select limit ms sql
SQL
0 vote180 views1 answer
Mariadb maximum left join
SQL
0 vote176 views1 answer
Select a row include list of array with join table SQL
SQL
9 votes183 views3 answers
Mysql show table column full description
SQL
1 vote172 views2 answers
Find a column in all tables mysql
SQL
0 vote181 views1 answer
Change date in pivot table to month in sql server
SQL