Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: milliseconds supported in PDI

  1. #1
    Join Date
    Sep 2012
    Posts
    25

    Default milliseconds supported in PDI

    hi,

    i am trying to load date with values in milliseconds - example 2013-06-27 17:50:40:414.
    is this supported in pdi CE 4.4?

    Thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Load from what to what?

    Text File Input / Output - Yes, PDI supports it.
    Table Input / Output - That depends on if your DB supports it.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Sep 2012
    Posts
    25

    Default

    i am trying to load from Flat file to Infobright Database.

  4. #4
    Join Date
    Sep 2012
    Posts
    25

    Default

    if millseconds is supported, how do i specify in the format? mm/dd/yyyy hh:mm:ss?

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

    Default

    Recommended reading: SimpleDateFormat
    So long, and thanks for all the fish.

  6. #6
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    according to http://docs.oracle.com/javase/1.4.2/...ateFormat.html

    it would be:
    Code:
    mm/dd/yyyy hh:mm:ss.SSS
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.