Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date conversion question
Kevin,
I assume that when you say "date fields" you think they are char (or varchar2) fields with the dates inside. Under that assumption, try this:
to_date(trans_date,'YYYYMMDD HH24:MI:SS') = to_date(value_date,'DD-MON-YY HH24:MI:SS')
Regards,
Tanya
--
Tanya Injac
Oracle Developer/DBA
Unisys NZ Ltd
Kevin Bass <akil1_at_mindspring.com> wrote in article
<6kkqce$fhf$1_at_camel21.mindspring.com>...
> I have two date fields with the following information (data):
>
> trans_date ==> 19980528 00:00:00
> value_date ==> 28-MAY-98 00:00:00
>
> How can I compare these two date fields?
>
>
> Kevin
>
Received on Thu May 28 1998 - 21:42:14 CDT