Extracting year portion of date

[posiedon]

Hi

I wish to select the distinct year from a series of rows in a table. the date column is in the format dd:mon:yyyy:hh24:mi:ss, how do i retrieve the distinct year part from these rows?


Thanks in advance

Stephen

 

[neilsie]

u can convert it into a chr string, and format thus:

select to_char(sysdate,'yyyy') from dual;

br,
Neil.

 

[Guest_imported]

Hi Stephen,
Pls try the following
"Select to_char(your_date_column_name,'yyyy') from your table_name"

Best Regs,
~ Parthi

 

[sem]

To leave the type of your DATE column use

select distinct trunc(<your_column>,'Y')