SQL query for extracting year from a date

Question

I am trying to create a query that gets only the year from selected dates  I e  select ASOFDATE from PSASOFDATE  returns 11 15 2012  but I want only 2012  How can I get only the year  I know the YEAR function can be used  but I m not sure how

User · Answer

This worked for me   SELECT EXTRACT YEAR FROM ASOFDATE  FROM PSASOFDATE

User · Answer

SELECT date column name FROM table name WHERE  EXTRACT YEAR FROM date column name    2020

User · Answer

just pass the columnName as parameter of YEAR  SELECT YEAR ASOFDATE  from PSASOFDATE    another is to use DATE FORMAT  SELECT DATE FORMAT ASOFDATE    Y   from PSASOFDATE     SQLFiddle Demo   UPDATE 1  I bet the value is varchar with the format MM dd YYYY  it that s the case   SELECT YEAR STR TO DATE  11 15 2012     m  d  Y        SQLFiddle Demo   LAST RESORT if all the queries fail  use SUBSTRING  SELECT SUBSTRING  11 15 2012   7  4     SQLFiddle Demo

User · Answer

How about this one   SELECT TO CHAR ASOFDATE   YYYY   FROM PSASOFDATE

User · Answer

Edit  due to post-tag  oracle   the first two queries become irrelevant  leaving 3rd query for oracle  For MySQL  SELECT YEAR ASOFDATE  FROM PASOFDATE  Editted  In anycase if your date is a String  let s convert it into a proper date format  And select the year out of it  SELECT YEAR STR TO DATE ASOFDATE    d- b- Y    FROM PSASOFDATE  Since you are trying Toad  can you check the following code  For Oracle  SELECT EXTRACT  TO DATE YEAR   MM DD YY   FROM ASOFDATE  FROM PSASOFDATE   Reference

[sql] SQL query for extracting year from a date

Examples related to sql

Examples related to oracle

Examples related to toad

Examples related to peoplesoft