Oracle Question Bossu..kathulu Randi

[Mr Mirchi]

v_last_date1    DATE;    --09-13-2012 06:09:46  

v_last_date2    DATE;     --09-13-2012 06:09:09

 

 

select date1, date2 into  v_last_date1, v_last_date2 from ABCD;   --date1, date 2 DATE datatypes

 

  IF v_last_date1 > v_last_date2 THEN   -- This should true, but returning false.

                        update TABLE

                         set remarks = 'Primary'

                        where user_id = '55654';

                         commit;

END IF;

 

 

naa Stored PROC lo....e values batti..pyna IF condition true return cheyaali...but false vasthumdi......format convert cheyalaaa?

[NewUser123]

http://stackoverflow.com/questions/10136506/get-time-difference-between-two-datetime-in-oracle

 

[Doola]

to_char(v_last_date1) > to_char(v_last_date2) ani try chy babai.......because date ni nuvvu aggregate function (>) tho compare cheyyalem kada 

[NewUser123]

http://stackoverflow.com/questions/10136506/get-time-difference-between-two-datetime-in-oracle

TODAY := TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-YYYY') ||
' 09:00:00', 'DD-MON-YYYY HH24:MI:SS');

IF PREVIOUS_DATE < TODAY AND
TO_DATE(CURRENT_DATE, 'DD-MON-YYYY HH24:MI:SS') >= TODAY THEN
-- do something
ELSE
-- do something else