Formating SYSDATE in SQL Loader

When I use SYSDATE in a SQL Loader scripts as a default date, it loads a data/time in the table.

ie PERIOD_EFFECTIVE_DATE SYSDATE

I would like just the date as you would get using trunc(sysdate) in sql. How is that done?

Thanks Received on Wed Mar 05 2003 - 11:45:44 CST