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.
Date format for Stringtodate()
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
-
- Participant
- Posts: 8
- Joined: Sat Apr 22, 2006 2:28 am
- Location: Bangalore
- Contact:
Date format
Hi,kris007 wrote: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
I agree with krish.
it looks like a julian date.
Thanks & Regards,
Subhani Basha Syed.
Subhani Basha Syed.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: