Date function in DB2

[mvchaudhari]

In framework manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated field in framework manager that will convert the dates for us.

 

[PruSQLer]

If the positions of the characters in the field are fixed, you can do this:


select substr(dait,1,2) || '/' || substr(dait,3,2) || '/' || substr(dait,5,4)
From TABLE_1

 

[Mercury2]

or perharps something like ...
Select
substr(Digits(NumDate), 1, 2) || '/' ||
substr(Digits(NumDate), 3, 2) || '/' ||
substr(Digits(NumDate), 5, 2) as ActDate
From ...