Skip site navigation (1) Skip section navigation (2)

Re: formating dates

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br>,pgsql-php(at)postgresql(dot)org
Subject: Re: formating dates
Date: 2005-06-14 19:58:17
Message-ID: 200506141258.17102.scrawford@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-php
On Tuesday 14 June 2005 12:44 pm, Ângelo Marcos Rigo wrote:
> Hi can i format dates from postgresql stored in the
> aaa-mm-dd format to June 14 2005 - Tuesday ?
>
> using just postgresql functions?

select to_char(now(), 'FMMonth dd yyyy - FMDay');

See to_char() documentation for more.

Cheers,
Steve


In response to

pgsql-php by date

Next:From: Bruno Wolff IIIDate: 2005-06-14 20:31:28
Subject: Re: formating dates
Previous:From: Philip HallstromDate: 2005-06-14 19:52:22
Subject: Re: formating dates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group