observation & question
From: Sergey V. Fedorishin <sfedor01_at_schema.fiu.edu>
Date: 1996/07/07
Message-ID: <4rooaf$fnl_at_isis.fiu.edu>#1/1
Date: 1996/07/07
Message-ID: <4rooaf$fnl_at_isis.fiu.edu>#1/1
why
select to_date( '1 1 96', 'MM DD YY')
from DUAL
/
doesn't work
while
select to_date( ' 3 3 96', 'DD MM YY')
from DUAL
/
works perfect?
Seems that it can handle leading spaces only.
Actually, this snippet comes from Loader problem: there are dates in input
file like
01 02 95
as well as
1 2 95
and it looks like there is no simple way to handle it (I know a couple
of non-simple ways).
Any comment?
TIA
-Sergey.
Received on Sun Jul 07 1996 - 00:00:00 CEST