Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Change Date format through metadata injection

  1. #1
    Join Date
    Apr 2009

    Default Change Date format through metadata injection

    I'm trying to copy some 100+ tables from MySQL (table input SELECT *) to Snowflake (SF Bulk Loader). When trying to copy data across these the timestamp fields needs to be converted from YYYY/MM/DD HH:MM:SS --> YYYY-MM-DD HH:MM:SS for snowflake to accept them. Problem is that I don't know a priori which fields have timestamps and I want to avoid mapping each table manually.

    So I'm wondering if anyone knows a way of using meta-data injection to identify which are the inbound timestamp fields and apply a Format of YYYY-MM-DD HH:MM:SS to them automatically?

    thx, sebastian

  2. #2
    Join Date
    Apr 2009


    I was able to solve this one on my own by setting a different default timestamp format in


    so no need to use metadata-injection for this.

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.