TO_DATE Conversion Problem for Time
Date: 1996/10/28
Message-ID: <009AA82E.1EE63D08_at_vms.csd.mu.edu>#1/1
I'm trying to use the TO_DATE function to convert a character date & time
to a DATE datatype field. I'm trying to convert a Registration Appointment
field (REGISTRATION_APP) that contains "0315961030" (March 15, 1996 10:30am).
The field is converted to a DATE but without the TIME. When I select the new
DATE field (REGISTRATION_APP2) I get 00:00:00 for the TIME.
Does anyone have any idea what I'm doing wrong.
SELECT TO_DATE(:REGISTRATION_APP,'MMDDYYHH24MI')
INTO :REGISTRATION_APP2 FROM DUAL
Ed Gryga
Marquette University
E-mail: grygae_at_vms.csd.mu.edu