Re: TO_DATE Conversion Problem for Time

I believe you need the forms column property sheet set to "DATETIME".

Ed Gryga - Marquette University wrote:
>
> 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).
>
> SELECT TO_DATE(:REGISTRATION_APP,'MMDDYYHH24MI')
> INTO :REGISTRATION_APP2 FROM DUAL
>
> 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.
>
> Ed Gryga
> Marquette University
> E-mail: grygae_at_vms.csd.mu.edu
Received on Mon Oct 28 1996 - 00:00:00 CET