How to Retrieve Time In Date Columns From Database
(Doc ID 2948573.1)
Last updated on MAY 18, 2023
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
How to Retrieve date along with time for date columns from database?
For example: In the application, the Applied Date and Released Date of hold applied on sales order shows date and time.
On running the below query, it fetches only date without time.
Query for Applied Date
SELECT CREATION_DATE from OE_HOLD_SOURCES;
Query for Released Date
SELECT CREATION_DATE from OE_HOLD_RELEASES;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document