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
Sql ignore
SQL
-1 vote114 views2 answers
Full join sql
SQL
0 vote129 views1 answer
Order child below the parent in mysqli
SQL
4 votes105 views1 answer
What are the data types in sql
SQL
9 votes135 views2 answers
SELECT User,Host FROM mysql.user;
SQL
1 vote119 views1 answer
What is intersect
SQL
0 vote106 views1 answer
Print intervals of 15 minutes in sql query
SQL
-1 vote107 views1 answer
Sql syntax create timestamp column
SQL
0 vote123 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote128 views1 answer
Ceil upto 2 decimal place mysql
SQL