DECLARE @intDatetime int = 20140327 DECLARE @strDatetime VARCHAR(10) = convert(varchar(10),@intDatetime) SELECT 'Date time in MM/dd/yyyy Format' = convert(VARCHAR(10),convert(datetime,@strDatetime),101)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)