Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: date conversion question

Re: date conversion question

From: Tanya Injac <tanyainjac_at_unn.unisys.com>
Date: 29 May 1998 02:42:14 GMT
Message-ID: <01bd8aab$64fd3b40$6762df81@nz6220.nz.unisys.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US