/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

5 votes136 views1 answer
Commentaire table oracle
SQL
0 vote123 views1 answer
Sql where time stamp is in between
SQL
1 vote136 views1 answer
Change table to innodb mysql
SQL
0 vote145 views1 answer
Get create sql of hibernqte entity
SQL
10 votes142 views6 answers
Sql between
SQL
0 vote194 views1 answer
Mac os zsh: command not found: mysql
SQL
14 votes197 views1 answer
How to export db from mysql
SQL
0 vote156 views1 answer
Sql date with year
SQL
1 vote202 views1 answer
Truncate table in postgresql and reset id
SQL
-2 votes136 views1 answer
No module named '_sqlite3
SQL

Share