Re: Problem: SQL*Loader and SYSDATE.

From: Suzanne Rose <Suzanne.M.Rose_at_DaytonOH.NCR.COM>
Date: 1997/12/19
Message-ID: <01bd0c8c$673f5340$95761995_at_aohemd4berarb.DaytonOH.NCR.COM>#1/1


Mikhail,

        Since SYSDATE is a date and time variable, your date column contains bothe a date and time. When you do a date comparison, Oracle uses 00:00 as the time portion of the date if the time is not specified. Since the time portion of your date column is probably not 00:00, you'll need to do a date conversion to do the comparison (for example TO_CHAR(<column_name>, 'DD-MON-YY') = 'the date').

        If you don't want the time set in your date column, use TRUNC(SYSDATE) to fill the column. This will fill the column with the date value but leave the time portion "blank".

Hope that helps.
Suzanne Rose
NCR Corporation

Mikhail <mike_at_gncom.com> wrote in article <3497740E.2CE236D3_at_gncom.com>...
> 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 Fri Dec 19 1997 - 00:00:00 CET

Original text of this message