Oracle Analytics Publisher

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
96
Views
3
Comments
Satya.Munagala
Satya.Munagala Rank 2 - Community Beginner

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 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.