Pentaho

 View Only
Back to discussions
Expand all | Collapse all

Report Designer How to have a function to convert Unix Epoch column value to date time format

This thread has been viewed 2 times

  • 1.  Report Designer How to have a function to convert Unix Epoch column value to date time format

    Posted 08-22-2023 05:37

    Hi

    I am currently able to use the Report Designer to connect to the Oracle database.

    However, in my table, all the date time field values are stored in Unix Epoch values.

    How can i convert these values into date time format dd/mm/yyyy hh:nn for these fields in the report?

    please advise

    regards

    chris



    ------------------------------
    Chris Chuah
    Systems Engineer
    Infologic Pte Ltd
    ------------------------------


  • 2.  RE: Report Designer How to have a function to convert Unix Epoch column value to date time format

    Posted 08-23-2023 13:52

    Hi Chris,

    IMHO no, Open Formula does not have this function.  I can try this options.

    • Convert epoch direct in SQL query on Oracle Server.
    • From epoch calculate all fields of timestamp (year, month, day, etc.).
    • Use BeanShell scripting of value.


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

    Original Message


Related Content