Select to_char(yourdatecol,‘YYYY’) from yourtable.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Datepart | 1 | 1443 | August 3, 2010 | |
| Number to date DDMMYYYY | 4 | 4807 | December 26, 2018 | |
| Need to extract YYYYMM from YYYY/MM | 4 | 1825 | July 6, 2018 | |
| SQL query runs fine in TOAD, but not on UNIX (sqlplus) [defined as DATE] | 3 | 570 | May 26, 2010 | |
| To_char function producing unexpected results | 4 | 195 | April 2, 2024 |