Convert integer to date using SQL in iSeries DB2

Revision: 53072

at November 12, 2011 02:21 by wnasich

Initial Code

SELECT
date(substr(char(intfield), 1, 4) || '-'|| substr(char(intfield),5, 2) || '-'|| substr(char(intfield), 7, 2)) AS datefield
FROM file1

Initial URL

Initial Description

intfield has this format: YYYYMMDD

Initial Title

Convert integer to date using SQL in iSeries DB2

Initial Tags

sql, date

Initial Language

SQL