Is it possible to have a column with such timestamp?
I don't see anything like that:
Hi @Stefano_Mazzocca,
Thanks for the details.
As per the screenshot the column is only storing the date part and time part you are getting it's a default value like 00:00:00.
If you are looking for Current Timestamp then you can use CURRENT_TIMESTAMP similar like CURRENT_DATE.
Cheers,
Is your source column having Timestamp?
You can CAST a date column to Timestamp in the following way.
CAST("COL NAME" AS TIMESTAMP)
Hope this help.
Hi @Bhaskar Konar, I don't have a specific column, I need the current timestamp as column.
My list is this one:
So if I do CAST(DATE AS TIMESTAMP) I have the wrong time:
Hi @Bhaskar Konar really close!
I now just need to remove the am/pm format (24 hours format) . Is it possible?
Found it!
Thank you
Glad to hear that.
Thank you very much @Stefano_Mazzocca!
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
In FDI Payroll Costing subject area there is out of the box column for Transfer to GL Flag / Indicator, I've tried searching through tables in subject area to add physical column for transfer to GL Date but no luck. Does anyone know how I can populate a transfer to GL date in payroll costing? We are attempting to build a…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
