Hi All, I have the most simple sql query ever I am writing to a file
select policy, rdate from ada1
as expected, rdate is being returned in the 5 digit date format. Is there any SIMPLE way to do this on the fly, that doesnt require me from writing a stored procedure
What I have:
db2 => select policy, rdate from ada1
POLICY RDATE
-------------------------------------------------- ------
3741474 17479
What I want:
What I have:
db2 => select policy, rdate from ada1
POLICY RDATE
-------------------------------------------------- ------
3741474 11/08/17
Thanks