Categories
- All Categories
- 151 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Need timestamp along with date as input parameter in Oracle BIP report

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