Select DISTINCT(TO_NUMBER(TO_CHAR(VISIT_DATE, 'YYYY'))) as YEAR from HISTORY
No. | Subject | Author | Date | Views |
---|---|---|---|---|
6 | DATE -> DAY CONVERT SQL | admin | 2023.05.25 | 38 |
5 | ORACLE COLLECTION | admin | 2023.05.08 | 38 |
4 | Monthly SUM | admin | 2023.05.22 | 37 |
3 | INNER JOIN | admin | 2023.05.19 | 37 |
2 | TEST | admin | 2023.05.03 | 36 |
» | YEAR EXPRESSIONS | admin | 2023.05.25 | 34 |