Обсуждение: FORMATTING DATES

Поиск
Список
Период
Сортировка

FORMATTING DATES

От
JORGE MALDONADO
Дата:
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

От
ANdreas Wenk
Дата:
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