Return last 2 digits of the Year ??

[Guest_imported]

How can I return the last 2 digits of the year into a variable?

SELECT DATEPART(yy, GETDATE()) ---> returns 2001 ... I only want 01 returned.

Thx,
BT

 

[xcata]

Hi,

select substring(convert(varchar,getdate(),101),9,2)
or

select substring(convert(varchar,datepart(year,getdate())),3,2)

xcata.