/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 vote284 views1 answer
Sql server select value large text
SQL
0 vote280 views2 answers
Nested query
SQL
4 votes275 views2 answers
Postgresql reset sequence
SQL
0 vote283 views1 answer
How to move a column to different spot mysql
SQL
0 vote292 views1 answer
Login failed for user sql server
SQL
79 votes510 views6 answers
Grepper code
SQL
0 vote296 views2 answers
Pop sql insert value into
SQL
0 vote299 views2 answers
How to prevent sql injection in java
SQL
0 vote266 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote317 views1 answer
How to change mysql root password in windows 10
SQL

Share