IT

Articles 146

How to convert DATE to NUMBER

admin

2018.05.27 21:59:00 (*.90.61.5)

410

select to_char(CONTRIBUTION_DATE,'YYYY') from contribution

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

List Update Delete

No.		Author	Date	Views
146	QRCODE	admin	May 25, 2020	589
145	General JK	admin	Feb 05, 2019	1015
144	SQL ACTION	admin	Jan 11, 2019	1953
143	SQL SELECT last_name FROM	admin	Dec 12, 2018	861
142	General IMP	admin	Oct 08, 2018	906
141	SQL CREATE TABLE	admin	Sep 25, 2018	690
140	General Change Admin PASSWORD	admin	Jul 31, 2018	482
139	SQL VERY IMPORTANT	admin	Jun 26, 2018	433
138	IF/ELSE ... CASE WHEN	admin	Jun 25, 2018	338
137	SQL MISSIONARY_SUB	admin	Jun 25, 2018	403
136	General eeeeee	admin	Jun 21, 2018	457
135	SQL TABLE PRINT	admin	Jun 18, 2018	406
134	SQL GP PRINT	admin	May 31, 2018	436
	SQL How to convert DATE to NUMBER	admin	May 27, 2018	410
132	SQL DATE Compare	admin	May 22, 2018	409
131	General If you want to use EXISTS in a PL/SQL function returning BOOLEAN	admin	May 19, 2018	465
130	General use a validation function for an element in apex 5.0	admin	May 19, 2018	468
129	General Validation to detect text in numeric field	admin	May 19, 2018	467
128	General All Data DELETE from Table	admin	May 10, 2018	441
127	General Process	admin	May 05, 2018	466

Write List

First Page 1 2 3 4 5 6 7 8 Last Page