Re: How to convert postgres timestamp to date: yyyy-mm-dd

> I need to convert postgres timestamp to date format yyyy-mm-dd in a
> sql statement.
> pt.created_date below is timestamp format
>
> i.e ... WHERE pt.created_date >=  '2008-01-21'
>
> Any help would be greatly appreciated.

Try this:

WHERE pt.created_date >= '2008-01-21'::date