Re: date conversion question

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 29 May 1998 11:51:02 GMT
Message-ID: <01bd8af8$056e0220$47c3657e@polcar_nt4006>

Hi,
the following lines should give you an idea what can be done with such data:

create table xxx(d1 date,d2 date);
insert into xxx values(to_date('19980528 00:00:00','YYYYMMDD HH24:MI:SS'),

                      to_date('28-MAY-98 00:00:00','DD-MON-YY

HH24:MI:SS'));
select 1 from xxx
where d1=d2;

              1

---

              1

 select 1 from xxx
 where d1>d2

no rows selected

--
Pavel Polcar

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 Fri May 29 1998 - 06:51:02 CDT