Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Get System Info (Date) - getting numeric value in Output Step not Date

  1. #1

    Question Get System Info (Date) - getting numeric value in Output Step not Date

    I am using the Get System Info and used different types .. but when I write to an output step I get a numeric value "41629.0". I am setting the stream field as "Date" in the output step.

    Is this the best way to get Date? What am I missing?

    Thanks,

    KP

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    If you use Get System Info to retrieve the current system date, you will get a Date field with a default mask.
    I wonder how you manage to write the epoch days with a field type of Date.
    Can you attach a demo?
    So long, and thanks for all the fish.

  3. #3

    Default

    Here is a screenshot .... still getting epoch time... using PDI 4.4

    Name:  Date.jpg
Views: 42
Size:  32.3 KB

    Do you need the transform file?

    KP

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I wish I could read the format string you specified in the Excel Writer step.
    So long, and thanks for all the fish.

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.