Re: Force implicit data conversion
- From: "stephen van linge" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "swvanlinge@xxxxxxxxx" for DMARC)
- To: "l.flatz@xxxxxxxxxx" <l.flatz@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 Mar 2015 18:19:36 +0000 (UTC)
I suppose I could, I was hoping to avoid tkprof if possible, do you think abn
estimated execution plan is sufficient to find out which is being converted to
which?
Thanks,
Stephen
From: Lothar Flatz <l.flatz@xxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Monday, March 2, 2015 10:13 AM
Subject: Re: Force implicit data conversion
Hi Stephen,
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@xxxxxxxxx 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
Other related posts:
