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 vote308 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote338 views3 answers
Classement rang mysql 7
SQL
0 vote312 views1 answer
Mysql select last 15 minutes
SQL
6 votes305 views1 answer
SQL insert all columns
SQL
0 vote307 views1 answer
Postgresql create table with boolean column
SQL
2 votes335 views1 answer
Sql finding longest and shortest names in a fleld
SQL
20 votes371 views4 answers
How to find average in sql
SQL
0 vote315 views1 answer
What is the use of index in mysql table
SQL
6 votes364 views2 answers
Foreign key sqlite3 python
SQL
0 vote401 views1 answer
Plpgsql create function
SQL