SQL How to convert DATE to NUMBER

admin 2018.05.27 21:59 Views : 217

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	1598
64	QR-CODE	admin	2017.11.30	125
63	APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1	admin	2017.11.25	148
62	Building Mobile Applications with Oracle Application Express 5.0	admin	2017.11.25	75
61	image (products)	admin	2017.11.24	105
60	SQL Basics - Lesson 1 - Introduction	admin	2017.06.17	106
59	APEX Password Change	admin	2016.08.26	469
58	JavaScript for Member List	admin	2016.08.17	453
57	SQL	admin	2016.07.15	416
56	control break	admin	2016.06.25	411
55	Membership Management	admin	2016.06.09	454
54	function get area	admin	2016.06.08	345
53	How to set a proxy in UTL_HTTP	admin	2016.06.07	341
52	APEX Web Services Proxy Settings	admin	2016.06.07	380
51	DBMS_NETWORK_ACL_ADMIN	admin	2016.06.07	372
50	DBMS_NETWORK_ACL_ADMIN	admin	2016.06.07	357
49	Assign a network host to Access Control List	admin	2016.06.07	321
48	ADD_PRIVILEGE (2nd STEP)	admin	2016.06.07	373
47	CREATE_ACL (1st STEP)	admin	2016.06.07	329

Write Tag

First Page 1 2 3 4 5 6 7 Last Page