Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Postgres column interval

  1. #1
    Join Date
    May 2014
    Posts
    27

    Default Postgres column interval

    I'm trying to write to the Postgres in a column of type "interval", example:

    123h, 21m, 30s

    input: 123:21:30, column type "interval"

    output: 123:21:30, column type "interval"

    But the kettle read as input as text, and none of the formats "Meta-data" support "interval", any tips to solve?

    Thanks in advance!

  2. #2
    Join Date
    Mar 2013
    Posts
    127

    Default

    Hi,

    PFA workaround

    IntervalTest2.ktr

    Regards,
    Mateen

  3. #3
    Join Date
    May 2014
    Posts
    27

    Default

    Worked!

    Thanks MateenSA.

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.