Update record based on date format in oracle using c#

Jun 8 2017 9:15 AM

Sir,

Can , i have update query on which,i can update record based on datefromat in oracle using c#

I have tried both this.

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

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

Please help me out,what I am doing wrong

Answers (3)