Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table Output Date+Time

  1. #1
    Join Date
    Apr 2009
    Posts
    12

    Default Table Output Date+Time

    Any way to get a Table Output step to write to a date-time field and include the time?

    When I save the date-time with the format: "DD-MMM-YY" it's fine, but when I try to include the time, such as: "DD-MMM-YY HH:MM:SS.sss", I get the (Oracle) error: "ORA-01830: date format picture ends before converting entire input string". It's as if the table output step hard-codes a format string that does not include the time. So how do I specify a date format string in a Table Output, Insert/Update or Update step?

    This is Kettle 3.2 GA, with an Oracle 10.2 database.

    Thanks.

  2. #2
    Join Date
    Jun 2010
    Posts
    114

    Default

    In the link, http://www.techonthenet.com/oracle/errors/ora01830.php
    it says that "In Oracle, the default date format is generally DD-MON-YYYY. If you try to enter a date value that does not comply with this format, you need to use the to_date function."

    So, may be, you can use Execute sql script step and in the query, you can mention format in the todate function like to_date('13-DEC-2004 6:56 PM', 'dd-mon-yyyy hh:mi PM')
    Well, there should be definetly better ways to do this.

    Goodluck
    Thanks,
    Om
    ----------------------
    Spoon version -4.4.0

  3. #3
    Join Date
    Apr 2009
    Posts
    12

    Default

    That should work; I'll give it a try. I'll second the sentiment that there should be a better way. Thanks.

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.