-- grepper SQL All Date Display Conversions -- Date_Formats.sql -- This displays all Date and Time Formats for MSSQL -- example select convert(varchar(8), getdate(), 112); -- The 112 here is the date format option -- returns 20240310 -- end example DECLARE @counter int = 0 ,@date datetime2(3) = sysdatetime() --'2024-03-10 15:16:25.290' ; -- End DECLARE /** START #dateFormats table **/ DROP TABLE IF EXISTS #dateFormats; CREATE TABLE #dateFormats ( dateFormatOption int ,dateOutput varchar(40) ); /** END #dateFormats table **/ WHILE (@counter <= 150 ) BEGIN BEGIN TRY INSERT INTO #dateFormats SELECT CONVERT(varchar, @counter), CONVERT(varchar,@date, @counter) SET @counter = @counter + 1 END TRY BEGIN CATCH; SET @counter = @counter + 1 IF @counter >= 150 BREAK END CATCH END SELECT * FROM #dateFormats; DROP TABLE IF EXISTS #dateFormats; -- end grepperdf[Date] = pd.to_datetime(df[Date], format="%m%d%Y %H:%M:%S")