Re: Formating SYSDATE in SQL Loader

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 06 Mar 2003 08:15:27 -0800
Message-ID: <3E67741F.9584FE23@exesolutions.com>

Rick wrote:

> 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

Can't be done because date fields in Oracle always contain the time. The only possible work-around is to use the time at midnight for the date which is TRUNC(SYSDATE).

Daniel Morgan Received on Thu Mar 06 2003 - 10:15:27 CST