A column specified with SYSDATE
gets the current system date, as defined by the SQL language SYSDATE
parameter. See the section on the DATE
data type in Oracle Database SQL Language Reference.
The combination of column name and the SYSDATE
parameter is a complete column specification.
column_name SYSDATE
The database column must be of type CHAR
or DATE
. If the column is of type CHAR
, then the date is loaded in the form 'dd-mon-yy.' After the load, it can be loaded only in that form. If the system date is loaded into a DATE
column, then it can be loaded in a variety of forms that include the time and the date.
A new system date/time is used for each array of records inserted in a conventional path load and for each block of records loaded during a direct path load.