Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- d.date1,
- ylit,
- round(d.fat,1),
- round(d.snf,1),
- rs,
- round(rs*ylit,2),
- nlit,
- kalit,
- jlit
- from daily_milk as d,
- $rate_chart[0] as r
- where d.fat=r.fat
- && d.snf=r.snf
- && mtype='$mtype'
- && scode='$society_code_op[0]'
- && shift='सकाळ'
- && d.date1 between '$date1' and '$date2'
- && d.date1 between r.date1 and r.date2
- order by d.date1
- FLOOR(column_name * 100) / 100
- ROUND(column_name, 2)
- $var = 1.787;
- echo number_format((float)(FLOOR($var * 100) / 100), 2, '.', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement