What are the pros and cons of performing calculations in sql vs. in your applicationshopkeeper table has following fields: id (bigint),amount (numeric(19,2)),createddate (timestamp) Let's say, I have the above table. I want to get the records for yesterday and generate a report by having the amount printed to cents. One way of doing is to perform calculations in my java application and execute a simple query Date previousDate ;// $1 calculate in application Date todayDate;// $2 c
