SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 332

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
89	Change Admin PASSWORD	admin	2018.07.31	357
88	VERY IMPORTANT	admin	2018.06.26	314
87	IF/ELSE ... CASE WHEN	admin	2018.06.25	259
86	MISSIONARY_SUB	admin	2018.06.25	284
85	eeeeee	admin	2018.06.21	303
84	TABLE PRINT	admin	2018.06.18	294
83	GP PRINT	admin	2018.05.31	1068
»	How to convert DATE to NUMBER	admin	2018.05.27	332
81	DATE Compare	admin	2018.05.22	472
80	If you want to use EXISTS in a PL/SQL function returning BOOLEAN	admin	2018.05.19	324
79	use a validation function for an element in apex 5.0	admin	2018.05.19	296
78	Validation to detect text in numeric field	admin	2018.05.19	374
77	All Data DELETE from Table	admin	2018.05.10	327
76	Process	admin	2018.05.05	305
75	Oracle SQL Developer: Online Migration 3.1	admin	2018.04.25	226
74	How to Update Oracle XE	admin	2018.04.25	237
73	Oracle APEX 5.1.4 Installation	admin	2018.04.17	219
72	How to Update Oracle XE Version	admin	2018.02.23	986
71	Manufacturing resource planning (MRP II)	admin	2018.02.14	136
70	Material requirements planning (MRP)	admin	2018.02.14	174

Write Tag

First Page 1 2 3 4 5 6 7 Last Page