Default Date format

[Developer9]

Hi,

I am using teradata table as my target ..I need to insert the date fields in the format "mm/dd/yyyy"

Code: Select all

dataset ----->xfm -->Teradata

While writing to dataset I used varchar and assigned "mm/dd/yyyy"-- I am able to write data but I need to load the date fields in date format

What is the derivation to use in the transformer stage ?

Please let me know your input

Thanks

[chulett]

StringToDate() with the appropriate format string, I would assume.

[abc123]

When you wrote to the dataset, what data type did you write it as? You need to read it using the same data type. You can then manipulate the format downstream (if needed) using something like what Craig is suggesting.