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@bcbsm.com>
>To: pgsql-general@postgresql.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