How to Retrieve Time In Date Columns From Database (Doc ID 2948573.1)

Last updated on MAY 18, 2023

Applies to:

Symptoms

 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;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.