/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

1 vote117 views1 answer
STOP message of how many rows affected sql
SQL
0 vote116 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
16 votes114 views2 answers
Gremove folder from git
SQL
0 vote107 views1 answer
List mysql tables and views
SQL
0 vote110 views1 answer
Php delete database
SQL
4 votes114 views3 answers
Mysql update with join
SQL
3 votes117 views1 answer
Only join in sql
SQL
0 vote121 views1 answer
Sql reverse order of results
SQL
0 vote108 views1 answer
Error code 1241 mysql
SQL
0 vote116 views2 answers
Sql having multiple conditions
SQL

Share