/SQL/Sql server select where date

Sql server select where date

Sql server select where date

select * from test where cast ([date] as date) = '03/19/2014';

0

Source: stackoverflow.com

How to search date in sql query

 select * from test 
 where datediff(day, date, '03/19/2014') = 0

0

Source: stackoverflow.com

Similar codes

0 vote236 views1 answer
Set Mamp mysql globally
SQL
9 votes215 views4 answers
Add primary key to existing table sql
SQL
4 votes288 views1 answer
How to check last gather stats on table in oracle
SQL
10 votes221 views1 answer
Dba_dependencies
SQL
150 votes381 views10 answers
Grepper
SQL
0 vote225 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote242 views1 answer
Kill a pid redshift
SQL
0 vote222 views1 answer
Oracle sql date winter time
SQL
18 votes226 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote231 views1 answer
Mysql locate
SQL

Share