Re: date functions

hi,
How about using "date_part()" function , to extract yy and mm and dd and
then form them as you wish. ;)

>From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
>To: pgsql-general(at)postgresql(dot)org
>Subject: [GENERAL] date functions
>Date: Fri, 1 Feb 2002 08:53:40 -0500
>
>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]
>
>
>And maybe this:
>
>
>[example]
>
> date
>------------
> 01/07/2001
>
>[/example]
>
>
>Any suggestions? Thanks!
>
>-X

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx