Re: Force implicit data conversion

  • From: Lothar Flatz <l.flatz@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 02 Mar 2015 19:13:05 +0100

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



begin:vcard
fn:Lothar Flatz
n:Flatz;Lothar
email;internet:lflatz@xxxxxxx
tel;cell:+41786264331
version:2.1
end:vcard

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2015