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 votes162 views3 answers
Postgresql connection string c#
SQL
0 vote185 views1 answer
Default password for mysql_secure_installation in mac
SQL
1 vote169 views2 answers
Find a column in all tables mysql
SQL
0 vote192 views1 answer
Postgresql show owner of database
SQL
1 vote179 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote165 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote170 views1 answer
Sum value by month sql
SQL
0 vote161 views1 answer
Sql menampilkan data tabel
SQL
0 vote182 views1 answer
Mysql zerofill
SQL
1 vote170 views1 answer
Postgresql convert text to float
SQL