SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 197

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

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

I want to

List

Comment 0

No.	Subject	Author	Date	Views
86	MISSIONARY_SUB	admin	2018.06.25	198
85	eeeeee	admin	2018.06.21	217
84	TABLE PRINT	admin	2018.06.18	185
83	GP PRINT	admin	2018.05.31	917
»	How to convert DATE to NUMBER	admin	2018.05.27	197
81	DATE Compare	admin	2018.05.22	365
80	If you want to use EXISTS in a PL/SQL function returning BOOLEAN	admin	2018.05.19	215
79	use a validation function for an element in apex 5.0	admin	2018.05.19	204
78	Validation to detect text in numeric field	admin	2018.05.19	229
77	All Data DELETE from Table	admin	2018.05.10	198
76	Process	admin	2018.05.05	211
75	Oracle SQL Developer: Online Migration 3.1	admin	2018.04.25	119
74	How to Update Oracle XE	admin	2018.04.25	137
73	Oracle APEX 5.1.4 Installation	admin	2018.04.17	131
72	How to Update Oracle XE Version	admin	2018.02.23	929
71	Manufacturing resource planning (MRP II)	admin	2018.02.14	78
70	Material requirements planning (MRP)	admin	2018.02.14	87
69	What Is ERP?	admin	2018.02.14	120
68	Link- AbbaBeauty	admin	2018.02.13	84
67	Apex Interactive Report: The difference between CIR and RIR	admin	2018.01.26	80

Write Tag

First Page 1 2 3 4 5 6 7 Last Page