Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. select
  2. d.date1,
  3. ylit,
  4. round(d.fat,1),
  5. round(d.snf,1),
  6. rs,
  7. round(rs*ylit,2),
  8. nlit,
  9. kalit,
  10. jlit
  11. from daily_milk as d,
  12. $rate_chart[0] as r
  13. where d.fat=r.fat
  14. && d.snf=r.snf
  15. && mtype='$mtype'
  16. && scode='$society_code_op[0]'
  17. && shift='सकाळ'
  18. && d.date1 between '$date1' and '$date2'
  19. && d.date1 between r.date1 and r.date2
  20. order by d.date1
  21.  
  22. FLOOR(column_name * 100) / 100
  23.  
  24. ROUND(column_name, 2)
  25.  
  26. $var = 1.787;
  27. echo number_format((float)(FLOOR($var * 100) / 100), 2, '.', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement