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@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