I have an array based date column called Billinvoicedate which is of date type.I want to calculate and fetch all the yesterday records for that particular date column.But i am constantly getting error while trying different sort of sql queries. e.g. select * from pe_cust_ren_sub where DATE(_pe.rensu...