UDB Date conversion - SQL support

Is there any UDB supported single date conversion function that will take a
date formatted as MM/DD/CCYY and return it formatted as CCYY/MM/DD? I've
been told that such a function exists in other database products.

Thanks

Try char(datefield,ISO)...should return CCYY-MM-DD.

Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> Rebecca A Bond
> Sent: Wednesday, October 06, 1999 4:46 PM
> To: [login to unmask email]
> Subject: UDB Date conversion - SQL support
>
>
> Is there any UDB supported single date conversion function that
> will take a
> date formatted as MM/DD/CCYY and return it formatted as CCYY/MM/DD? I've
> been told that such a function exists in other database products.
>
> Thanks
>