SQL statement about Date(編號:5589)

How can use sql to get records where "date" is greater or equal to today ?
e.g.
select * from schedule where eventdate >= 'aug/23/2000'
thanks a lot for help !