I need to get the date in the format ddmmyy, I'm using SQL Server 2000.
I've tried using :-
DECLARE @Date varchar(15)
SET @Date = convert(varchar,getdate(),112)
Obviously 112 is the wrong style but I can't find a style in the documentation that converts to the format ddmmyy.