Viewing post 1 (of 1 total)
SELECT convert(varchar(3), DATEDIFF ( day , '01/Jan/'+ltrim(str(year(getdate()))) , getdate())) + '-' + convert(varchar(4), YEAR(getdate()))
This Will Solve the Problem, remember very first number will be zero.
February 11, 2004 at 12:53 am
#493558