Thread: Changing date style output format

Changing date style output format

From
Adam Witney
Date:
Hi,

I was wondering if it was possible to output a date in this format

4th May 2003

Thanks for any help

Adam


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


Re: Changing date style output format

From
Arguile
Date:
On Sun, 2003-05-04 at 16:25, Adam Witney wrote:
>
> Hi,
>
> I was wondering if it was possible to output a date in this format
>
> 4th May 2003

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-formatting.html

Everything you ever wanted to know about formatting dates in PostgreSQL.