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

7 votes162 views5 answers
Oracle alter table
SQL
1 vote156 views1 answer
Create new table in SQL from old table with data
SQL
2 votes162 views1 answer
Pdo mysql insert
SQL
2 votes167 views1 answer
Guid to string sql
SQL
6 votes164 views2 answers
Join vs union
SQL
5 votes151 views2 answers
Update all rows mysql
SQL
1 vote188 views1 answer
Autocommit mysql
SQL
0 vote181 views1 answer
Get create sql of hibernqte entity
SQL
14 votes170 views1 answer
Oracle new column
SQL
1 vote173 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL