Postgres Pro
Downloads
Home   >   mailing lists

Re: FORMATTING DATES - Mailing list pgsql-novice

From ANdreas Wenk
Subject Re: FORMATTING DATES
Date
Msg-id 4A591497.9040408@netzmeister-st-pauli.de
Whole thread Raw
In response to FORMATTING DATES  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: FORMATTING DATES
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: cannot locate where dataase files are stored