Postgres Pro
Downloads
Home   >   mailing lists

Thread: FORMATTING DATES

FORMATTING DATES

From
JORGE MALDONADO
Date:
I have a SELECT statement which gets records from a table some of them being dates that display date and time.
How can I use formatting so that only the date part is displayed?
 
With respect,
Jorge Maldonado

Re: FORMATTING DATES

From
ANdreas Wenk
Date:
JORGE MALDONADO wrote:
> I have a SELECT statement which gets records from a table some of them
> being dates that display date and time.
> How can I use formatting so that only the date part is displayed?
>
> With respect,
> Jorge Maldonado

Hi,

use the formatting function to_char() ...

http://www.postgresql.org/docs/8.4/static/functions-formatting.html

Cheers

Andy