today:
112
yesterday:
177
Total:
1,001,029

SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 198

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

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

I want to
List
No. Subject Author Date Views
66 JAVA for delete admin 2016.04.28 154
65 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
64 DELETE PROCESS admin 2016.04.28 157
63 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 158
62 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 158
61 INSERT PROCESS admin 2016.04.28 159
60 SQL SELECT DISTINCT Statement admin 2016.04.29 160
59 EXPORT & IMPORT admin 2016.05.01 166
58 UPDATE PROCESS admin 2016.04.28 167
57 CREATE TABLESPACE admin 2016.04.28 170
56 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
55 Captcha Test file admin 2016.04.18 176
54 Apex setup procedure admin 2016.04.28 180
53 TABLE PRINT admin 2018.06.18 186
» How to convert DATE to NUMBER admin 2018.05.27 198
51 All Data DELETE from Table admin 2018.05.10 199
50 MISSIONARY_SUB admin 2018.06.25 199
49 Name Show admin 2016.04.28 203
48 use a validation function for an element in apex 5.0 admin 2018.05.19 205
47 IF/ELSE ... CASE WHEN admin 2018.06.25 209
Write Tag