What is the command for this?

Databases
1

Hi,

My table has a column date, which has dates stored in format YYYY-MM-DD format.
Now I want to get the records, where date equals 2012-04-18.
Can someone tell me what query should be run for this?

2 
WHERE datecolumn = '2012-04-18'