Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: date problem with Kettle

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default date problem with Kettle

    Good morning,


    I'm loading and excel file and I'm specifying the type as a date but Kettle returns to me always the same value 1970/01/01 instead of
    20041231
    20041231
    20051024
    20060331
    20060329
    20060329



    The format is yyyymmdd.



    If anybody has a clue.



    Thanks a lot



    Nicolas de Fontenay

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: date problem with Kettle

    Hi Nicolas,


    Kettle found a number or a string in the excel sheet and tried to do a conversion on it.
    Try to look in the excel sheet and see if it's really a date, rather then a number or a string.



    In release 2.3.0 (due in less then a month) we'll have conversion logic for Excel as well.



    At the moment the work-around is to read it in as a String and do the conversion yourself using a small piece of javascript:



    field.str2dat("yyyyMMdd");



    Thanks for your patience,
    Matt

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.