select convert(varchar,getDate(),111,112,113......)
declare @d varchar(11) select @d = CONVERT(varchar(11),current_timestamp,109) select RIGHT(@d,4) + '-' + LEFT(@d,3) + '-' + right('00'+LTRIM(SUBSTRING(@d,5,2)),2)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)