DB2API stage

mrvsr · Post by **mrvsr** » Thu Jul 17, 2008 2:22 pm

Hi
I am trying to get the data from DB2 using API stage .
I am selecting a field datatype is date and in result it showing the date as below.
14792 (2008-06-30)
But I am expecting only (2008-06-30).

Please let me know how can I eliminate the Internal date representation(14792)

Thanks

ArndW · Post by **ArndW** » Fri Jul 18, 2008 1:04 am

Where are you displaying this date-as-string, and are you certain this is a PX and not a Server job?

Cr.Cezon · Post by **Cr.Cezon** » Fri Jul 18, 2008 5:21 am

DataStage shows you :
14792 that is the internal date format.
If you don't want ro use internal date format of DS use type = char.