aravinth kandasamy

aravinth kandasamy

  • NA
  • 73
  • 27.8k

How to update the month and year ?

Apr 18 2015 7:16 AM
How to update the month and year ?

My update query is

Update tbfacilityreceiptitems set  Batchno ='    D001',mfgdate=10/2014,expdate=12/2020, MRP =10, sellingprice = 0.32, SaleTaxPercentage = null , SaleTaxType = 'null' where facreceiptitemid = 2763

Please help me and rearrange my update query


I am waiting for your reply....

Answers (2)