Force implicit data conversion

  • From: "stephen van linge" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "swvanlinge@xxxxxxxxx" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 Mar 2015 18:08:47 +0000 (UTC)

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: