invalid input syntax for type date: "10-2014"

aravinth kandasamy

Update tbfacilityreceiptitems set itemID = 13902, Batchno ='b002' ,mfgdate = '10-2014', expdate = '10-2019', MRP =10.0000, SingleUnitPrice= 9.4500, marginPercentage = 10.00, sellingprice = 0.32, SaletaxID = 34, TaxPercentage = 0.00, SaleTaxPercentage = 5.00 , SaleTaxType = ' VAT S', sellingpricesku = 9.4500where facreceiptitemid = 2681

Please give correct answer

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

aravinth kandasamy11y ago
this is mfgdate and expdate...So i don't need day..
0
aravinth kandasamy11y ago
This is my update query but query was not updated..Please help me My Query is Update tbfacilityreceiptitems set itemID = 13902, Batchno ='b002' ,mfgdate = '10-2014', expdate = '10-2019', MRP =10.0000, SingleUnitPrice= 9.4500, marginPercentage = 10.00, sellingprice = 0.32, SaletaxID = 34, TaxPercentage = 0.00, SaleTaxPercentage = 5.00 , SaleTaxType = ' VAT S', sellingpricesku = 9.4500where facreceiptitemid = 2681 Error:invalid input syntax for type date: "10-2014" Please correct my Query i am waiting for your reply
0
Tom Mohan11y ago
Why you are not giving day ?
0