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

6 votes277 views1 answer
How to count number of rows in sql
SQL
6 votes206 views1 answer
Postgres get size of database
SQL
0 vote248 views2 answers
How to truncate all table in mysql workbench
SQL
1 vote186 views3 answers
Grant syntax in sql
SQL
4 votes193 views1 answer
Oracle error compilation line
SQL
2 votes197 views1 answer
Date conversion in mysql column
SQL
0 vote278 views1 answer
How many rows affected in sqllite
SQL
0 vote216 views1 answer
Oracle sql drop table
SQL
0 vote226 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote189 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL