extract year from date

[mplbm]

How do you extract the year from a datetime field?


Thanks,

Mike

 

[vongrunt]

YEAR(datecolumn)

Or DATEPART(yy, datecolumn)

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[mplbm]

Sorry, I meant how do you get the full date i.e. dd/mm/yyyy, removing just the time. How do I do this?

 

[vongrunt]

faq183-5842, tip #7.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]