Re: Problem: SQL*Loader and SYSDATE.

You are dealing with a date field.
There are many ways to do this. Try:

                trunc(column_name)='17-DEC-97'
                rtrim(column_name)='17-DEC-97'
                column_name like '17-DEC-97'
                to_char(column_name,'DD-MON-YY') = '17-DEC-97'
                to_char(column_name) = '17-DEC-97'

Mikhail wrote:

> Hi All !
> I have a problem with SQL*Loader(Release 7.2.2.3.1)
> When I use:
> <column_name> SYSDATE,
> in the *.CTL file, I've got the date, but SQL*Plus doesn't recognize
> it.
> I see the date in the <column_name>, but I am not able do SELECT
> <column_name> FROM <table> WHERE
> <column_name>='the date'.
> If you have had this problem please explain me what's going on.
> Thank you for your time.
> Mikhail (mike_at_gncom.com).
Received on Wed Dec 17 1997 - 00:00:00 CET