SQL*LOADER and SYSDATE

From: <jtkelly_at_my-dejanews.com>
Date: Tue, 16 Mar 1999 21:48:27 GMT
Message-ID: <7cmjj8$uq1$1@nnrp1.dejanews.com>

Can someone please help

I would like to be able to load a file and change a date field to some date in the future (something like):

TO_DATE(TO_CHAR(SYSDATE + 1, 'MM/DD/YYYY'), 'MM/DD/YYYY') in a SQL LOADER control file for a date field. But everytime I try this and other combinations I always get an error. What am I doing wrong?

Thanks in advance
john

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 16 1999 - 15:48:27 CST