how to retrieve data from sql table according to date?

See more:

SQL

hello i am wondering how ti retrieve data from sql table arcording to the date..

as an example. if i would like to retrieve a specific or a row of data from a table from date a.

select * from table where table.date = a;

but i would like to make a command to retrieve a data to retrieve data when it was equal to date a or before the date a..

select * from table where table.date = a or ......;

can anyone help me to continue this?? or may be i got some error on the format ..