Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date conversion question
Here is an example .....
select '1' from <table_name>
where
to_date(trans_date,'yyyymmdd hh24:mi:ss') = to_date(value_date,'dd-mon-yy hh24:mi:ss);
Robert Prendin
RP Data Solutions
"Kevin Bass" <akil1_at_mindspring.com> wrote:
>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:04:06 CDT