today:
198
yesterday:
221
Total:
1,109,854

SQL How to convert DATE to NUMBER

admin 2018.05.27 22:59 Views : 268

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

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