Skip to Content
0
Former Member
Nov 18, 2013 at 09:45 PM

Date formatting from Jullian to regular date?

58 Views

Hi,

i am working on a universe which is using IBM DB2 database,

i have a field which is using Jullian Date format (Data type numeric)

it looks like this

2120426

CYYMMDD

i want to convert this to regular date D/m/yyyy

please suggest me how to do this.

Thanks