Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Publisher Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need timestamp along with date as input parameter in Oracle BIP report

Received Response
413
Views
3
Comments
Satya.Munagala
Satya.Munagala Rank 2 - Community Beginner
in Oracle Analytics Publisher Forum

Hi All,

We have a requirement in BIP report where user need to enter the date along with time (hours, minutes and seconds).

Does anyone come across similar requirement or any thoughts please let us know.

Thanks in Advance

Satya.M

Tagged:

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics & AI Lead

    Set the date format of the date parameter to a valid JAVA format that includes time.

    Ex: MM-dd-yyyy hh:mm:ss

    You can also read about Date Paramters here:

    https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-0D9ECE19-8672-43FD-B4E2-68074296C54F.htm#GUID-1FA3A641-1CE3-4B91-B788-F46E5E5B7777

    Rgds,

    Kevin

  • Satya.Munagala
    Satya.Munagala Rank 2 - Community Beginner

    Hi Kevin,

    Thanks.

    Timestamp is working now. but we also need to select the timezone.

    Tried this syntax yyyy-MM-dd hh:mm:ss.SSSZ. But it is not working as expected.

    Let us know if you have any working syntax for the same.

    Regards,

    Satya.M

  • Swati epari
    Swati epari Rank 1 - Community Starter

    Hi,

    I have tried yyyy-MM-dd hh:mm:ss.SSSZ as well, it did not work.

    Can someone through some inputs on this one.