Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: values of date data type is getting migrated incorrectly

  1. #1

    Exclamation values of date data type is getting migrated incorrectly

    i am reading data through teiid connection (which connects to a virtual DB which in turn fetches data from SQL server DB) and storing it in a SQL server DB. there a one column which is of datetime data type at source and having value '2016-09-11 10:25:00.000' . when data gets migrated to destination db value changes to '2016-09-11 15:25:00.000'.

  2. #2
    Join Date
    Apr 2012
    Posts
    3

    Default

    This sounds like there is an environment timezone difference between your source db -> Pentaho instance -> destination db.

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.