MVSFORUMS.com

jayram99 · Posted: Wed Feb 16, 2005 10:32 pm Post subject: Date Conversion

Hi,

At present i have date format(DB2) mm/dd/yyyy and i need date to be converted in the format yymmdd.

I want to execute the sql query in SAS application and write to a flat file.

Pl. help me to resolve this.

Jayaram

kolusu · Posted: Thu Feb 17, 2005 8:39 am Post subject:

jayaram99,

try this

jayram99 · Posted: Thu Feb 17, 2005 9:16 am Post subject:

Srihari,

If i code the query, will get the value from the first argument specified as string. The querry will return A.(First 2 Characters from A.DT_GR_FUNDG).

Actually I should get value from the date.

SELECT A.NBR_GRP,
SUBSTR('A.DT_GRP_FUNDG',1,2)

FROM UDBADM.MRTG_GRP A, UDBADM.CD_DLP B
WHERE A.CD_DLP=B.CD_DLP
AND B.CD_FMLY_TYPE = 'SF'

The results are
------------------------------------------------------------------------

NBR_GRP 2
------- --
H008701 A.
H008703 A.
H008702 A.

At present the DT_GRP_FUNDG column in table has 01/28/2005 , I should get 050128.

Thanks
Jayaram

jayram99 · Posted: Thu Feb 17, 2005 9:55 am Post subject:

kolusu,

Got the results, Thanks for the same.

I used the following query to get the results as per the requirement.