Re: Extracting date from timestamp

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Extracting date from timestamp
Date: 2005-05-06 13:37:49
Message-ID: 20050506133749.GB85993@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2005-05-06 13:38:50 Re: Slony v. DBMirror
Previous Message Michael Fuhr 2005-05-06 13:31:24 Re: Cursor problem