Select to_char(yourdatecol,‘YYYY’) from yourtable.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Datepart | 1 | 1519 | August 3, 2010 | |
| Different results with and without to_date function | 6 | 2188 | January 3, 2011 | |
| Different results with and without to_date function | 12 | 1446 | January 6, 2011 | |
| TOAD, SQL SERVER, date fields Where clause | 3 | 1205 | April 17, 2013 | |
| Number to date DDMMYYYY | 4 | 5761 | December 26, 2018 |