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

On Mar 11, 2008, at 2:50 PM, A. Kretschmer wrote:

>> i.e ... WHERE pt.created_date >=  '2008-01-21'
>
> You can't compare a date or timestamp to a varchar or text. For your
> example, cast the date-string to a real date like:

Since which version of Pg?

Queries like the above have worked for me from 7.3 up thru 8.1, which
is my current production environment.