IBM Mainframe Forum

by **mfraj81** » Mon Jan 31, 2011 11:52 am

Hi all,

I have a field which stores the date in the format 'yyyymmdd'. I required to split it into 'yyyy-mm-dd'. Could you please let me help me with correct query?

by **mfraj81** » Mon Jan 31, 2011 11:54 am

Hi all,

I have a field which stores the date in the format 'yyyymmdd'. I required to split it into 'yyyy-mm-dd'. Could you please help me with correct query?

by **alexm** » Mon Jan 31, 2011 8:51 pm

You may try this - however, it might be time consuming, depending on how much data you're going to process:

Select all

SELECT SUBSTR(Colname,1,4) CONCAT '-' CONCAT
SUBSTR(Colname,5,2) CONCAT '-' CONCAT
SUBSTR(Colname,7,2)
FROM your-table
WHERE ... ;

by **mfraj81** » Tue Feb 01, 2011 4:24 pm

Thank you it's working.

IBM Mainframe Forum

date format coverting

date format coverting

Re: date format coverting

Re: date format coverting

Re: date format coverting