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

Satya.Munagala

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

Kevin M-Oracle

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

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

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.