PDA

View Full Version : Date transformation



zwink2
01-26-2008, 07:56 PM
We are using spoon to move data from a flat as/400 file to MySQL. We are having a problem with the date format. The input date is yyyymmdd.
All the dates are being loaded into MySQL as 01011970, which we realize is a default date (or date zero). How do we get the dates to transform properly?

kmende
01-31-2008, 05:47 AM
Try using a select-value-step. In tab Meta-data you can define the format of the fields.