Postgres Pro
Downloads
Home   >   mailing lists

How to convert postgres timestamp to date: yyyy-mm-dd - Mailing list pgsql-general

From CaseT
Subject How to convert postgres timestamp to date: yyyy-mm-dd
Date
Msg-id dd57bbe6-6b91-4505-a952-e634c2c08ef8@i29g2000prf.googlegroups.com
Whole thread Raw
Responses Re: How to convert postgres timestamp to date: yyyy-mm-dd  ("Adam Rich" <adam.r@sbcglobal.net>)
Re: How to convert postgres timestamp to date: yyyy-mm-dd  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Kynn Jones"
Date:
Subject: Re: ISO something like "#if 0 ... #endif" for SQL code
Next
From: "A. Kretschmer"
Date:
Subject: Re: basic plpgsql / sql funtion question