Re: Problem: SQL*Loader and SYSDATE.

Oracle stores the date in a internal format you have one of two choices for your where clause

where

    trunc(column_name) = 'the date' e.g. '15 Dec 97' presuming default settings

or
where
column)name = to_date('yyyy mm dd hh24:mi', '1997 12 15 08:00')

something similar to one of the above should return the right record

--
Len Wickens
Senior Oracle/Unix Analyst
Object Oriented Programming Systems Corp
Mikhail wrote in message <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).

>



begin 666 Leonard Wickens.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E=I8VME;G,[3&5O;F%R9 T*
M1DXZ3&5O;F%R9"!7:6-K96YS#0I/4D<Z3V)J96-T($]R:65N=&5D(%!R;V=R
M86UM:6YG(%-Y<W1E;7,_at_0V]R< T*5$E43$4Z4V5N:6]R($%N86QY<W0-"E1%
M3#M(3TU%.U9/24-%.C0P,RTT.#DM,SDY.0T*5$5,.T-%3$P[5D])0T4Z-# S
M+CDT,"XR.3DX#0I!1%([5T]22SH[-# S+C0X.2XS.3DY#0I,04)%3#M73U)+
M.C0P,RXT.#DN,SDY.0T*14U!24P[4%)%1CM)3E1%4DY%5#IL96Y 8WEB97(M
M=VEZ87)D+F-O;0T*14U!24P[24Y415).150Z;&5N0'8M=V%V92YC;VT-"D5-
M04E,.TE.5$523D54.F]O<'-?7T!V+7=A=F4N8V]M#0I2158Z,3DY-S$R,3=4
4,#4P-C0T6_at_T*14Y$.E9#05)$#0H`
`
end
end