Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting date from timestamp - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Extracting date from timestamp
Date
Msg-id 20050506133749.GB85993@winnie.fuhr.org
Whole thread Raw
In response to Extracting date from timestamp  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
List pgsql-general
Tree view 
On Fri, May 06, 2005 at 06:26:14PM +0530, Nageshwar Rao wrote:
>
> How to extract date(mm/dd/yyy) from a timestamp .

You could cast the timestamp to date.  See also "Data Type Formatting
Functions" and "Date/Time Functions and Operators" in the "Functions
and Operators" chapter of the documentation.

http://www.postgresql.org/docs/8.0/interactive/functions-formatting.html
http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Cursor problem
Next
From: Brad Nicholson
Date:
Subject: Re: Slony v. DBMirror