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

2 votes329 views2 answers
Postgresql date at timezone
SQL
0 vote348 views1 answer
SQL Server Enterprise
SQL
0 vote351 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote333 views1 answer
Import excel to sql
SQL
0 vote340 views1 answer
T-SQL Never ending DELETE
SQL
0 vote368 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote650 views1 answer
How to connect .sql data set to powerbi
SQL
2 votes346 views1 answer
Query any digits record
SQL
7 votes341 views3 answers
Restore postgres database from sql file
SQL
0 vote391 views1 answer
Sql server phone constraint
SQL