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: Robert Prendin <rprendin_at_magi.com>
Date: Fri, 29 May 1998 02:04:06 GMT
Message-ID: <356e19ac.120598741@news.istar.ca>


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

Original text of this message

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