Hi Rodney,

SELECT char(datefield, USA) ... FROM TABLE
should do it.

HTH,
_________________________
Jean-Marc BLAISE
IDB Consulting

----- Original Message -----
From: "Rodney_G_Williams"
<db2udbdba-ezmlmshield-x39936152.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, May 26, 2006 6:46 PM
Subject: DB2 date format


> Is there a formatting function that will convert an ISO date format
> (yyyy-mm-dd) column into USA in a SELECT statement without the pain of
> manually parsing the DateColumn, etc?
>
> Rod Williams
>
> IT Delivery - Service Restoration
> Dominion Resources Services, Inc.
> 701 E. Cary St. - 7th Floor NW
> Richmond, VA 23219-3934
> 8-736-6189 office tie line
> 804-775-6189 office external
>
>
>
> -----------------------------------------
> CONFIDENTIALITY NOTICE: This electronic message contains
> information which may be legally confidential and/or privileged and
> does not in any case represent a firm ENERGY COMMODITY bid or offer
> relating thereto which binds the sender without an additional
> express written confirmation to that effect. The information is
> intended solely for the individual or entity named above and access
> by anyone else is unauthorized. If you are not the intended
> recipient, any disclosure, copying, distribution, or use of the
> contents of this information is prohibited and may be unlawful. If
> you have received this electronic transmission in error, please
> reply immediately to the sender that you have received the message
> in error, and delete it. Thank you.
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> --------------------------------------------------------------------------
-------------
> Wanadoo vous informe que cet e-mail a ete controle par l'anti-virus mail.
> Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page