Force implicit data conversion
From: stephen van linge <swvanlinge_at_yahoo.com>
Date: Mon, 02 Mar 2015 18:08:47 +0000
Message-ID: <179674154.1854227.1425319727297.JavaMail.yahoo_at_mail.yahoo.com>
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
Date: Mon, 02 Mar 2015 18:08:47 +0000
Message-ID: <179674154.1854227.1425319727297.JavaMail.yahoo_at_mail.yahoo.com>
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-lReceived on Mon Mar 02 2015 - 19:08:47 CET