Hello Friends
I am trying to load data from a flat file into a teradata table. I have some date values in my flat file like
RECEIPT_DT = 20070623000000
Which i am loading in a date type filed of teradata. I am using the modify stage for the conversion but its giving me an error. I am putting the value as follows in my modify stage
RECEIPT_DT:Date=date_from_string["%mm/%dd/%yyyy %hh%nn%ss"](RECEIPT_DT).
Can you please help me in letting me know the problem.
Thanks
Date Conversion error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Tue Mar 20, 2007 3:30 am
- Location: India