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

8 votes361 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote257 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote260 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote281 views2 answers
Truncate table sqlite
SQL
5 votes265 views3 answers
Db begintransaction laravel
SQL
25 votes269 views6 answers
How to change column name in mysql
SQL
0 vote249 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
9 votes284 views3 answers
Pyodbc connect to sql server
SQL
4 votes261 views2 answers
Sql offset
SQL
0 vote276 views1 answer
Select a row include list of array with join table SQL
SQL