ahmedrahil786

Socar Points Vs bank Transfer - Redeem vs Earned

Sep 19th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. #### Reimbursements - Socar Points Vs Bank Transfer
  2.  
  3. select fr.id, fr.state, fr.type ,fr.requested_amount, date(fr.created_at + interval 8 hour) as created_date from fuel_reimbursements fr ;
  4.  
  5. ######### Earned Vs Redeemed
  6. select p.id, p.state, p.type ,p.point, date(p.created_at + interval 8 hour) as created_date from points p;
Add Comment
Please, Sign In to add comment