SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 206

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
66	QR Code plugin Process	admin	2017.11.30	968
65	QR Code plugin	admin	2017.11.30	1595
64	QR-CODE	admin	2017.11.30	120
63	APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1	admin	2017.11.25	145
62	Building Mobile Applications with Oracle Application Express 5.0	admin	2017.11.25	71
61	image (products)	admin	2017.11.24	99
60	SQL Basics - Lesson 1 - Introduction	admin	2017.06.17	101
59	APEX Password Change	admin	2016.08.26	467
58	JavaScript for Member List	admin	2016.08.17	441
57	SQL	admin	2016.07.15	404
56	control break	admin	2016.06.25	407
55	Membership Management	admin	2016.06.09	441
54	function get area	admin	2016.06.08	334
53	How to set a proxy in UTL_HTTP	admin	2016.06.07	329
52	APEX Web Services Proxy Settings	admin	2016.06.07	372
51	DBMS_NETWORK_ACL_ADMIN	admin	2016.06.07	361
50	DBMS_NETWORK_ACL_ADMIN	admin	2016.06.07	348
49	Assign a network host to Access Control List	admin	2016.06.07	309
48	ADD_PRIVILEGE (2nd STEP)	admin	2016.06.07	360
47	CREATE_ACL (1st STEP)	admin	2016.06.07	320

Write Tag

First Page 1 2 3 4 5 6 7 Last Page