Select to_char(yourdatecol,‘YYYY’) from yourtable.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Datepart | 1 | 1457 | August 3, 2010 | |
| Number to date DDMMYYYY | 4 | 4953 | December 26, 2018 | |
| Need to extract YYYYMM from YYYY/MM | 4 | 1832 | July 6, 2018 | |
| To_char function producing unexpected results | 6 | 227 | January 7, 2025 | |
| SQL query runs fine in TOAD, but not on UNIX (sqlplus) [defined as DATE] | 3 | 571 | May 26, 2010 |