Search found 17 matches

Go to advanced search

by StuM
Sat May 13, 2006 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting MM/DD/YY date to DD/MM/YYYY in EE
Replies: 6
Views: 2430

ArndW wrote:It seems that your settings for the $APT_DATE_CENTURY_BREAK_YEAR are such that this conversion works incorrectly. You can also specifically force a century for a 2 digit date by using %year_cutoffy ...


Thanks very much for the info, I shall have a play and see how it goes.

Cheers
StuM
by StuM
Fri May 12, 2006 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting MM/DD/YY date to DD/MM/YYYY in EE
Replies: 6
Views: 2430

Converting MM/DD/YY date to DD/MM/YYYY in EE

Hi All, I am trying to convert a character date, format: MM/DD/YY to a character date, format: DD/MM/YYYY In Server Edition, this was easily taken care of using oconv, but now tht we are moving onto EE, I am having difficulty. I tried the following: DateToString(StringToDate(Trim(lkDatesStripped.Dat...

Go to advanced search