today:
161
yesterday:
311
Total:
1,018,400

SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 217

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

select to_number(to_char(CONTRIBUTION_DATE,'YYYY')) from contribution