Title: RE: To_Char Problem
a) Do not convert date fields to characters in a comparison. In your query, use
and a.updated_date = (select max(updated_date) ...
b) If you absolutely want to create two character strings from a date, and then compare the strings, this is the format to use
try this
select distinct(a.default_type_id), a.new_val
from amend_default_value a, amend_default_value b
where a.effective_from <= sysdate and
a.effective_to>= sysdate and
a.group_id = '942' and
a.default_type_id = b.default_type_id and
a.updated_da
because it is.
its not a problem with oracle, its a problem with the way the query is
written.
make the date mask /MM/DD HH24:MI:SS instead.
last i checked in math101, a number(or character string) 8 digits long,
that starts with a 31 is larger than an 8 digit number starting with 01.
jo
because it is.
its not a problem with oracle, its a problem with the way the query is
written.
make the date mask /MM/DD HH24:MI:SS instead.
last i checked in math101, a number(or character string) 8 digits long,
that starts with a 31 is larger than an 8 digit number starting with 01.
jo
Why would you want to do that - convert two dates into a char and then
compare them ? This is not a problem but it is how char comparisions work.
They are compared char by char to see which one is greater on the ASCII
chart.
See this : SQL > select '1' from dual where '3' > '10';
'
-
1
Babu
Why do you need the to_char?
But wouldn't it work anyway with
to_char(a.updated_date,'dd/mm/ hh24:mi:ss') =
( select to_char(max(updated_date),'dd/mm/ hh24:mi:ss'))
which will also use the 24 hour clock instead of
to_char(a.updated_date,'dd/mm/ hh:mi:ss') =
( selec
Hi All,
I am using the to_char function in the following query. But it treats the date
'31/12/2001' as greater than '01/01/2002'.
Is there any solution to fix this problem?
select distinct(a.default_type_id), a.new_val
from amend_default_value a, amend_default_value b
where a.effectiv