Date format for Stringtodate()

[bala_135]

Hi,

My input date is 1052003(dmmyyyy).I am getting this field as a varchar field(length 7).

I want to convert this into date field(yyyy-mm-dd)

In transformer i am using the function StringToDate()

I assume StringToDate() takes only the exact date format(ie if i get the input field as 01-05-2003 then i can use the function stringtodate())
Its perfectly working fine.

My input is 1052003(dmmyyyy).So i am splitting the input value as
d in one stage variable,mm in one stage variable,yyyy in one stage varibale.

and concatenating all the three as below
Year:'-':Month:'-':Day

When i try to load this in oracle(10g) i am getting the following warning.

INSERT_AR,0: Invalid date value in getInputFieldAsDate() for field '10' of input dataset '0'.

I am assuming that the problem is with the format because i tested with a hardcoded date(2003-12-01) into the table its getting properly inserted.

Kindly let me know where i am going wrong.

Any inputs would be appreciated.

Regards,
Bala.

[kris007]

How can a date be in such a format..dmmyyyy

From first look, your date format looks like a Julian date.(dddyyyy) where ddd is the nth day of that year. Use the Date and Time Functions in the Transformer and convert it into the format you need.

IHTH

[ray.wurlod]

What happens if the day number is greater than 9?

[rkdatastage]

hi

Check the date size , i hope that you are having a clear idea that in general date format is DD-MM-YYYY as its size is of 8 characters , but in your requirement you had specified as 7 characters where we will get a problem when the the give date is of 2 digit length .

RK

[syed_subhaan]

How can a date be in such a format..dmmyyyy

From first look, your date format looks like a Julian date.(dddyyyy) where ddd is the nth day of that year. Use the Date and Time Functions in the Transformer and convert it into the format you need.

IHTH

Hi,
I agree with krish.
it looks like a julian date.

[ray.wurlod]

So that 1052003 is the 105th day of the year 2003. The correct date format string would be "%ddd%yyyy".