Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dates in where clause using to_date and =
The date datatype can be viewed as a "continuous" rather than a "discrete" variable for practical purposes. That means, that one identifies a correct value by positioning the given value within an interval or acceptable margin of error. In the case of dates this interval is often a whole day, but it could be a shorter interval.
The reason you are having trouble with the equals sign is that the equals sign is generally not useful with respect to datatypes that represent continuous variables.
Frank Hubeny
Peter Shankey wrote:
> I evidentally do not understand the use of the equals sign with repect
> to date
> formating. Could someone explain where I am missing it.
>
Received on Mon Aug 07 2000 - 00:00:00 CDT