Year function giving full date as a result instead of just the year

1

Hi everyone!
When I use the YEAR(date) function, I get as a result the first day of that year.

For example:
YEAR(03/04/2009) I get as a result: 'Jan 1, 2009' instead of just '2009'

Thanks in advance!

2

Which dw are you using? Is that a custom column or just a sql statement?

3

I'm using MySQL and it's a SQL statement