To get the time of the particular ,To get the Current time of the DB

--To get the time of the particular column


Select LAST_UPDATE_DATE,To_char(LAST_UPDATE_DATE,'DD-MON-YYYY HH24:MI:SS') from Apps.PO_HEADERS_ALL Where PO_HEADER_ID ='2005';


--To get the Current time of the DB

Select To_char(sysdate,'DD-MON-YYYY HH24:MI:SS') Current_Time from Dual

Post a Comment