Re: sysdate on sqlldr

Gary Turner wrote:
>
> does anyone know how to get the date and time using the sysdate function on
> sqlldr. i can only get the date to be displayed. i have tried the on two
> different operating systems and see the same output.
A date datatype includes time. You can do the following in SQL*Plus:

1. alter session set NLS_DATE_FORMAT = <date/time picture>;
2. select to_char(column, <date/time picture>) from table;

See the Oracle docs for more info.

-- 
Ron Reidy
Oracle DBA