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

From: CaseT <ctorres(at)quantumcomposers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to convert postgres timestamp to date: yyyy-mm-dd
Date: 2008-03-11 17:51:21
Message-ID: dd57bbe6-6b91-4505-a952-e634c2c08ef8@i29g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I'm a novice but learning quickly and I'm stumped on how to do this.

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.

Thanks, Case

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2008-03-11 18:12:15 Re: ISO something like "#if 0 ... #endif" for SQL code
Previous Message Robert Haas 2008-03-11 17:37:42 Re: contributing patches