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

aravinth kandasamy

11y1.4k.NET

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..

4 Replies

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

Pankaj Kumar Choudhary11y ago
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 Mohan11y ago
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
aravinth kandasamy11y ago
Sir please rearrange my update code..I am waiting foe your replay
Tom Mohan11y ago
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