Update record based on date format in oracle using c#

priyanka9y ago

Update STI.CANCELRECEIPT SET UPLOADED='Y' WHERE TO_DATE(CANCEL_DATE)='" + Convert.ToDateTime(dt.Rows(i)("CANCELDT").ToString).ToString("dd-MMM-yy") + "'

0

Nilesh Shah9y ago

did any answer work for you?

If the reply was helpful then please mark it as Answer.

Thanks!

0

Nilesh Shah9y ago

I suggest always dealing with date in any DB in the format of "YYYY/MM/DD", that's most unambigious format

on top of it, you should use the oracle TO_DATE() function

try the following it may work:

Update STI.CANCELRECEIPT SET UPLOADED='Y' WHERE CANCELDT=TO_DATE('" + Convert.ToDateTime(dt.Rows(i)("CANCELDT").ToString).ToString("yyyy/MM/dd") + "')"

0