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 vote145 views1 answer
Mysql locate
SQL
0 vote166 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote143 views1 answer
Max mysql
SQL
5 votes143 views6 answers
Sql add days to date
SQL
0 vote150 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote182 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote107 views1 answer
Expose db in virtualbox
SQL
0 vote167 views1 answer
Mysql join only one column
SQL
0 vote148 views1 answer
Create or replace view postgress
SQL
0 vote134 views1 answer
Set column width in sqlplus
SQL