This script gets current date, and converts it using all existing predefined formats between 1 and 255:
DECLARE @format int;
CREATE TABLE #temp (format int NULL, string varchar(20) NULL, date datetime NULL)
SET @format = 1;
WHILE @format < 256
BEGIN
BEGIN TRY
INSERT INTO #temp (format, string, date) VALUES(@format, CONVERT(varchar(20),getdate(),@format), getdate());
END TRY
BEGIN CATCH
END CATCH
SET @format = @format + 1;
END
SELECT * FROM #temp;
DROP TABLE #temp;
No comments:
Post a Comment