Re: FORMATTING DATES

From: ANdreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: FORMATTING DATES
Date: 2009-07-11 22:39:19
Message-ID: 4A591497.9040408@netzmeister-st-pauli.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2009-07-12 08:40:59 Re: cannot locate where dataase files are stored
Previous Message JORGE MALDONADO 2009-07-11 22:21:22 FORMATTING DATES