today:
459
yesterday:
456
Total:
1,015,785

SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 209

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

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

No. Subject Author Date Views
86 FOR LOOP admin 2016.05.20 283
85 SUBSTR admin 2016.05.26 283
84 CAPTCHA PLUG-IN admin 2016.05.27 308
83 Access Control List (ACL) admin 2016.06.07 354
82 Oracle 11g Access Control List for External Network Services admin 2016.06.07 307
81 ACL 보기 admin 2016.06.07 321
80 CREATE_ACL (1st STEP) admin 2016.06.07 325
79 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 365
78 Assign a network host to Access Control List admin 2016.06.07 312
77 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 351
76 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 367
75 APEX Web Services Proxy Settings admin 2016.06.07 376
74 How to set a proxy in UTL_HTTP admin 2016.06.07 333
73 function get area admin 2016.06.08 339
72 Membership Management admin 2016.06.09 446
71 control break admin 2016.06.25 410
70 SQL admin 2016.07.15 408
69 JavaScript for Member List admin 2016.08.17 446
68 APEX Password Change admin 2016.08.26 468
67 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 102