Update record based on date format in oracle using c#

Question

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