Re: Implicit datatype conversion
From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Mon, 12 Aug 2002 12:13:18 -0700
Message-ID: <aj919s$5ts$1_at_spiney.sierra.com>
Date: Mon, 12 Aug 2002 12:13:18 -0700
Message-ID: <aj919s$5ts$1_at_spiney.sierra.com>
select * from my_table where A_DATE_FIELD > '01-JAN-2002'
in this example, A_DATE_FIELD has datatype = DATE and we are comparing it to a STRING (datatype).
There are certain kinds of strings that Oracle will automatically convert as needed.
select * from my_table where A_NUMBER_FIELD > '05'
select * from dual where 5 = '0005'
are some examples
"mark" <nekoliko_1_at_yahoo.com> wrote in message
news:air05s$ahs$1_at_sunce.iskon.hr...
> Hi everyone,
> i wonder if anyone could explain me the difference between
> implicit datatype conversion in few examples of assignments and
> expression, because i have heard there is some difference between
> these to situations.
> thx
> mark
>
>
Received on Mon Aug 12 2002 - 21:13:18 CEST