to_date('04-DEC-97 08:30','DD-MON-YY HH24:MI') will be 04-DEC-97 00:00 why?????
From: Harvey Mark <IMCEAMS-EARTH_PO1_msmrh>
Date: 1997/12/08
Message-ID: <14D46DF9FC08D111AF8700805F68C0CF04CFA5_at_CONNERY>#1/1
>
> field name data type format
> ----------------------------------------------------------------------
> -------
> 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 :
> 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 Mon Dec 08 1997 - 00:00:00 CET
Date: 1997/12/08
Message-ID: <14D46DF9FC08D111AF8700805F68C0CF04CFA5_at_CONNERY>#1/1
I think the problem here is the to_char(START) bit of the time1 assignment - no format mask
has been specified.
I also do not understand what your "format" heading means ? In the database, all date columns are of type date and not a specific format. The format is purely a display characteristic.> 04-DEC-97 00:00 why?????
> ----------
> From: linannie_at_ms16.hinet.net
> (annie)[SMTP:linannie_at_ms16.hinet.net]
> Posted At: 05 December 1997 15:11
> Posted To: tools
> Conversation: to_date('04-DEC-97 08:30','DD-MON-YY HH24:MI')
> will be 04-DEC-97 00:00 why?????
> Subject: to_date('04-DEC-97 08:30','DD-MON-YY HH24:MI') will be
>
> field name data type format
> ----------------------------------------------------------------------
> -------
> 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 :
> 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 Mon Dec 08 1997 - 00:00:00 CET