Re: formating dates - Mailing list pgsql-php

From Steve Crawford
Subject Re: formating dates
Date
Msg-id 200506141258.17102.scrawford@pinpointresearch.com
Whole thread Raw
In response to formating dates  (Ângelo Marcos Rigo <angelo_rigo@yahoo.com.br>)
List 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


pgsql-php by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: formating dates
Next
From: Bruno Wolff III
Date:
Subject: Re: formating dates