Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Date transformation

  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Default Date transformation

    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?

  2. #2

    Default

    Try using a select-value-step. In tab Meta-data you can define the format of the fields.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.