Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Date 00/00/0000

  1. #1
    Join Date
    Aug 2007
    Posts
    5

    Default Date 00/00/0000

    Hello,

    In my data to integrate I've sometime null date declared as follows:
    00/00/0000

    When I tried to retrieve it from a text input file kettle change it in something like: 30/11/0002 whatever if I choose lenient or not?


    I want to be able to replace 00/00/0000 by null in the database.
    So if I can't retrieve 00/00/0000 in the stream field, it will be hard?

    Any idea?
    Thanks for your help
    Franck

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

    Default

    You should be able to specify 00/00/0000 in the "Null if" column.

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Just checked this using a text input step reading 00/00/00... the problem is that the Java date makes it go wrong. It seems it doesn't like 0's as days and months.

    Regards,
    Sven

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.