How to take the null values for dateint value in postgresql

Question

My Update query is

Update tbfacilityreceiptitems set itemID = 9345, Batchno = ' ' , mfgdate = 1/1/2012, expdate = 1/1/2020 , MRP =100.0000, SingleUnitPrice= 80.0000, marginPercentage = 20.00, sellingprice = 80.00, SaletaxID = 30, TaxPercentage = ' ' , TaxPercentage =' ' , SaleTaxPercentage =' ' , SaleTaxType ='' , sellingpricesku ='' where facreceiptitemid = 2291

please help me..

Pankaj Kumar Choudhary · Answer

hello @aravinth you can try this code Update tbfacilityreceiptitems set itemID = 9345 Batchno = NULL  mfgdate = 1/1/2012 expdate = 1/1/2020  MRP =100.0000 SingleUnitPrice= 80.0000 marginPercentage = 20.00 sellingprice = 80.00 SaletaxID = 30 TaxPercentage = NULL  TaxPercentage =NULL  SaleTaxPercentage =NULL  SaleTaxType =NULL  sellingpricesku = NULL where facreceiptitemid = 2291 if you get any type of problem then you can post that

Tom Mohan · Answer

Update tbfacilityreceiptitems set itemID = 9345 Batchno = ' '  mfgdate = 1/1/2012 expdate = NULL  MRP =100.0000 SingleUnitPrice= NULL marginPercentage = 20.00 sellingprice = 80.00 SaletaxID = 30 TaxPercentage = ' '  TaxPercentage =' '  SaleTaxPercentage =' '  SaleTaxType =''  sellingpricesku ='' where facreceiptitemid = 2291 I gave expdate and SingleUnitPrice as null

Tom Mohan · Answer

Just give like testdb =# UPDATE COMPANY SET ADDRESS = NULL  SALARY = NULL where ID IN ( 6  7 ); if you want learn more about null in postgresql refer http://www.tutorialspoint.com/postgresql/postgresql_null_values.htm

aravinth kandasamy · Answer

Sir please rearrange my update code..I am waiting foe your replay

How to take the null values for date,int value in postgresql