Re: date functions

On Fri, 2002-02-01 at 06:53, Johnson, Shaunn wrote:
> Howdy:
>
> Silly question. I want to display the date from
> my table in other formats. Is this possible?
>
> For example, I have this:
>
> [example]
>
> date
> ------------
> 2000-01-07
>
> [/example]
>
> And I want this:
>
> [example]
>
> date
> ------------
> 20000107
>
> [/example]

SELECT to_char(current_date, 'YYYYMMDD');

> And maybe this:
>
>
> [example]
>
> date
> ------------
> 01/07/2001
>
> [/example]

SELECT to_char(current_date, 'DD/MM/YYYY');

> Any suggestions? Thanks!

The to_char function does precisely what you need. You can find
excellent documentation in section 4.6 of the PostgreSQL User's guide.

Jason