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 vote125 views1 answer
C# mysql data reader from two tables
SQL
0 vote131 views1 answer
Sql create table with references not primary key
SQL
0 vote198 views1 answer
Mac os zsh: command not found: mysql
SQL
13 votes136 views1 answer
Select count of distinct values sql
SQL
0 vote129 views1 answer
Insert or update cassandra
SQL
0 vote133 views1 answer
Function sum(text) does not exist postgres
SQL
6 votes133 views2 answers
Stored procedure to delete data from table in mysql
SQL
1 vote139 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
19 votes132 views6 answers
Laravel sql query
SQL
0 vote142 views1 answer
Mariadb create index if not exists
SQL