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

Comment 0

No.	Subject	Author	Date	Views
86	If you want to use EXISTS in a PL/SQL function returning BOOLEAN	admin	2018.05.19	223
85	3D Pie Chart	admin	2016.05.17	222
84	Report by Order / Product / Order and Product / By Order & Non Order	admin	2016.04.29	220
83	Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 )	admin	2016.05.06	219
82	Process	admin	2018.05.05	218
81	CREATE VIEW	admin	2016.05.13	218
80	All Data DELETE from Table	admin	2018.05.10	211
79	IF/ELSE ... CASE WHEN	admin	2018.06.25	209
78	use a validation function for an element in apex 5.0	admin	2018.05.19	209
77	Name Show	admin	2016.04.28	203
76	MISSIONARY_SUB	admin	2018.06.25	199
»	How to convert DATE to NUMBER	admin	2018.05.27	198
74	TABLE PRINT	admin	2018.06.18	186
73	Apex setup procedure	admin	2016.04.28	182
72	Captcha Test	admin	2016.04.18	178
71	CREATE TABLESPACE	admin	2016.04.28	177
70	EXPORT & IMPORT	admin	2016.05.01	174
69	CREATING A TABLE / SEQUENCE / TRIGGER	admin	2016.04.28	172
68	UPDATE PROCESS	admin	2016.04.28	167
67	TAP ( Main & Sub ) / Button 의 Switch	admin	2016.04.28	166

Write Tag

First Page 1 2 3 4 5 6 7 Last Page