Re: Force implicit data conversion

how about doing a small test case? Look at the execution plan and you have your answer.

Thanks

Lothar
Am 02.03.15 um 19:08 schrieb stephen van linge (Redacted sender swvanlinge_at_yahoo.com for DMARC):
> Hi all,
>
> This is an academic question. Given a table A with column B
> (timestamp data type) and date parameter C, how can i force an
> implicit conversion within a select statement of B to date type?
>
> I'm looking at this:
>
> SELECT *
> FROM A
> WHERE B = C
>
> and I'm not sure if B is being converted to date, or if C is being
> converted to timestamp...
>
> Thanks,
>
> Stephen

--
http://www.freelists.org/webpage/oracle-l