Re: date conversion question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 29 May 1998 00:33:53 GMT
Message-ID: <356e0211.1173747@192.86.155.100>

A copy of this was sent to "Kevin Bass" <akil1_at_mindspring.com> (if that email address didn't require changing) On Thu, 28 May 1998 18:57:04 -0400, you 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?
>
>

to_date( trans_date, 'YYYYMMDD HH24:HI:SS' ) <>

      to_date( value_date, 'DD-MON-YY HH24:MI:SS' )

(or you might want to use DD-MON-RR in the date mask, its up to you... If your dates spill into the year 2000, that is, 28-MAY-05 is in the year 2005, then RR is the right format)

>Kevin
>
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 28 1998 - 19:33:53 CDT