Does anyone know how you can select the current date AND time from DUAL?
I know SELECT SYSDATE FROM DUAL returns the date, but not the time.
I need to write PL/SQL code that automatically inserts the exact time a record is created, into on of the fields.
Cheers.
I know SELECT SYSDATE FROM DUAL returns the date, but not the time.
I need to write PL/SQL code that automatically inserts the exact time a record is created, into on of the fields.
Cheers.