Search code examples
sqloracle-databaseora-00904

ORA-00904: "FORMAT": invalid identifier

I am trying to format a date:

FORMAT(table.TCKT.TCKT_ISS_DATE, 'YYYY') AS TICKETYEAR

but I am getting the following error:

ORA-00904: "FORMAT": invalid identifier

Right now the date show the complete timestamp. Any suggestions on how to fix this problem, or any other way to format the date to just show the four digit year?

Solution

  • Use this function:

    TO_CHAR(table.TCKT.TCKT_ISS_DATE, 'YYYY') AS TICKETYEAR