date format question

[zuohua zhang]

I have a date column in this format:
Mon Jul 16 14:05:12 PDT 2012

I want to select all records > 2012-09-01.

How to do?

Thanks!