Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: Extracting date from timestamp
Date
Msg-id 427B73D5.5020307@archonet.com
Whole thread Raw
In response to Extracting date from timestamp  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
List pgsql-general
Tree view 
Nageshwar Rao wrote:
> How to extract date(mm/dd/yyy) from a timestamp .

See chapter 9.8. Data Type Formatting Functions, all about to_char()

If you just want your preset format you can use SELECT now()::date;


--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: Slony v. DBMirror
Next
From: Richard Huxton
Date:
Subject: Re: postmaster crash - another server process exited abnormally