Greatest/ Least function

Dimpy

Hi Experts,

When i am using greatest function query is fetching smaller value and when i am using least function it fetches greater value. I am unable to understand the reason behind it.

Kindly help.

select LEAST(

(select value from scpomgr.zt_batch_Param where key_name ='MSEPER-MAX'),

(select MAX(DMDPOSTDATE) from SCPOMGR.SKUSAFETYSTOCKPARAM)-

to_date((SELECT value

FROM SCPOMGR.ZT_BATCH_PARAM 

WHERE KEY_NAME='STARTDATE_LAG_CAPTURE' ),'DD-MON-YY') 

) from dual;

User_H3J7U

select greatest('10', 5) g from dual;

G
-
5

select greatest(5, '10') g from dual;

         G
----------
        10

Dimpy

Hi @User_H3J7U,

Thanks for the help, I am able to fix the issue using to_number function.

Best Regards