RE: Date Conversion function

["ibm" <ibm@xxxxxxxxxx>]

I can always do this:
-- CONVERT MMDDYY TO CYYMMDD
SET JULIAN = ( YEAR ( SOME_DATE ) - 1900 ) * 10000 + ( MONTH ( SOME_DATE
) * 100 ) + DAY ( SOME_DATE ) ;

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of ibm
Sent: Tuesday, December 08, 2009 8:08 AM
To: Midrange Systems Technical Discussion
Subject: RE: Date Conversion function

Sorry,,, SQL (stored procedure).

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
Sent: Friday, December 04, 2009 4:37 PM
To: Midrange Systems Technical Discussion
Subject: Re: Date Conversion function

in what language?

in CL use CVTDAT, in RPG just move the data into a Date field.


Thanks,
Tommy Holden



From:   "ibm" <ibm@xxxxxxxxxx>
To:     "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Date:   12/04/2009 04:28 PM
Subject:        Date Conversion function
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



Is there a built-in function to convert MMDDYY to CYYMMDD?