Page 1 of 1

Date format conversion

PostPosted: Tue Aug 25, 2015 12:50 pm
by gauravfrankly
Hi All,
I have a FB file having multiple columns, date is one of them in format : 12-AUG-2015
I have to insert this date into Db2, so I want to change its format.
Can you suggest way to do it by Sort.(only format conversion) to mm/dd/yyyy or yyyy-mm-dd

Re: Date format conversion

PostPosted: Tue Aug 25, 2015 3:55 pm
by NicC
If it is a file - real term, 'dataset' - then each record has fields not columns. Columns in a record are the individual bytes. DB2 tables have rows that consist of one or more columns.

Re: Date format conversion

PostPosted: Tue Aug 25, 2015 4:16 pm
by BillyBoyo
Use CHANGE= to convert the month, and rearrange into the order you want with BUILD (or OVERLAY if at a different position in the record).