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 vote313 views1 answer
Test the postgresql db connection
SQL
0 vote321 views1 answer
Sql common columns
SQL
1 vote265 views1 answer
Alter user mysql native password
SQL
1 vote313 views1 answer
Jooq convert using gbk
SQL
3 votes310 views2 answers
Get current year sql
SQL
0 vote331 views1 answer
Best sql collation
SQL
0 vote311 views1 answer
Sql date d'aujourd'hui
SQL
3 votes305 views2 answers
Brew start mysql
SQL
0 vote335 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote331 views2 answers
Plpgsql
SQL