query is:
UPDATE SHIPMENT SET PRODCODE='LAN', SHIPQTY='39.54', REMARKS='MR BOPL', MISEQ='-1',SITEID='MR', SSEMPNO='31111110', S_GAUGE='412.54', E_GAUGE='389.50', DENSITY='800', TEMPERATURE='40.30', TEMPATEND='40.30', SEDATE=TO_DATE('10-Jul-2018 12:00 AM','dd-Mon-yyyy HH:MI AM'), WEIGHT_S='705.12', WEIGHT_E='665.58', SEEMPNO='31111110', TANKNO='1001'
WHERE KEYSEQ='60719' AND SSDATE=TO_DATE('09-Jul-2018 12:00 AM','dd-Mon-yyyy HH:MI AM');
THERE ARE 2 ROWS WITH SAME DATE WITH DIFFERENT TIME.
but i want to update both rows using only '09-Jul-2018' in where condition.
is it possible?
What I have tried:
i have tried trunc(), to_char(). also tried SSDATE=TO_DATE('09-Jul-2018','DD-MM-YY)