Re: Formating SYSDATE in SQL Loader

From: FC <flavio_at_tin.it>
Date: Thu, 06 Mar 2003 18:11:47 GMT
Message-ID: <DbM9a.19565$zo2.579618@news2.tin.it>

Try as follows:

PERIOD_EFFECTIVE_DATE POSITION(1:1) CHAR "TRUNC(SYSDATE)" Bye,
Flavio

"Rick" <rick_markham_at_earthlink.net> wrote in message news:cb07c0ba.0303050945.617e1277_at_posting.google.com...
> 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 Thu Mar 06 2003 - 12:11:47 CST