如何在oracle中只使用日期更新行而没有时间？ [英] How to update row using only date without time in oracle?

问题描述

查询是：



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'）;





有两条行的日期与不同的时间。

但我想只使用'09 -Jul-2018'来更新两行条件。



可能吗？



我尝试了什么：



i尝试过trunc（），to_char（）。还试过SSDATE = TO_DATE（'09 -Jul-2018'，'DD-MM-YY）

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)

推荐答案

请检查一下...



DATE_FORMAT [ ^ ]



干杯

Hi,

Kindly check this ...

DATE_FORMAT[^]

Cheers

这篇关于如何在oracle中只使用日期更新行而没有时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！