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 vote116 views1 answer
Call function in query sql server
SQL
0 vote150 views1 answer
When mysql server would not work in xampp
SQL
0 vote118 views1 answer
Mysql server not starting in xampp in mac
SQL
5 votes146 views3 answers
Select tables from mysql database
SQL
0 vote153 views1 answer
Mariadb hours between two dates
SQL
8 votes170 views6 answers
Insert command in sql
SQL
0 vote118 views1 answer
Sql menampilkan data tabel
SQL
0 vote133 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote81 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote123 views1 answer
Sql query to delete row by id
SQL