Pentaho

 View Only
Back to discussions
Expand all | Collapse all

Date values are converted into Timestamps in Pentaho Version 9

This thread has been viewed 9 times

  • 1.  Date values are converted into Timestamps in Pentaho Version 9

    Posted 07-20-2023 09:03

    Hi All,

    After migrating from Pentaho version 5 to Pentaho 9.3, we were facing date conversion issues in the Excel extracts. Date values are automatically getting converted into timestamp value while writing into an Excel file.  Let me know if there is any workaround to avoid this issue.

     Thanks in Advance



    ------------------------------
    Thanks & Regards

    Saikrishna Vadlakonda
    Deloitte Consulting LLP.
    saikrishna5@deloitte.com | www.deloitte.com

    Please consider the environment before printing.
    ------------------------------


  • 2.  RE: Date values are converted into Timestamps in Pentaho Version 9

    Posted 08-04-2023 12:05

    Hi Saikrishna,

    what is source of data, table input step or something else? This is too less information.

    If source is table in DB, problem is that database has set support for timestamp data type (it's default settings and is added in PDI v5.2 ). Check settings and try disable this settings.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------

    Original Message


Related Content