to_date('04-DEC-97 08:30','DD-MON-YY HH24:MI') will be 04-DEC-97 00:00 why?????
From: annie <linannie_at_ms16.hinet.net>
Date: 1997/12/05
Message-ID: <348818c0.4709836_at_netnews.hinet.net>#1/1
if DAY is 04-DEC-97 , START is 08:30
the data type of time1 is CHAR
the data type of time2 is DATE
Date: 1997/12/05
Message-ID: <348818c0.4709836_at_netnews.hinet.net>#1/1
field name data type format
[Quoted] DAY DATE DD-MON-YY START DATE HH24:MI
if DAY is 04-DEC-97 , START is 08:30
the data type of time1 is CHAR
the data type of time2 is DATE
I write :
[Quoted] time1:=to_char(DAY)||' '||to_char(START);
time2:=to_date(time1,'DD-MON-YY HH24:MI');
the time1 will be '04-DEC-97 08:30' ---> it's data type is char
why time2 will be 04-DEC-97 00:00 ^^^^^^^WHY??? Please tell me! THANKS! Received on Fri Dec 05 1997 - 00:00:00 CET