Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: December 31, 1969 4:00 pm

  1. #1

    Default December 31, 1969 4:00 pm

    I would like to load, when appropriate, NULL values into a table. However, somewhere in the course of my transformation, December 31, 1969 4:00 pm get populated rather than NULL. Any thoughts how I might work around this, short of a database trigger?

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

    Default

    Not really much information to go on... What do you do... update/insert, table output, dimension lookup/update? which type of database.

    As a test replace what ever you write to the database with by a text output step (or just preview that part).

    Regards,
    Sven

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

    Default

    A hunch... epoch is 0, which is begin 1970 (give or take a few hours with timezones)... you're forcing a numeric 0 in a date?

    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.