xxxxxxxxxx
df[Date] = pd.to_datetime(df[Date], format="%m%d%Y %H:%M:%S")
xxxxxxxxxx
print(DateTime.parse('2020-01-02')); // 2020-01-02 00:00:00.000
print(DateTime.parse('20200102')); // 2020-01-02 00:00:00.000
print(DateTime.parse('-12345-03-04')); // -12345-03-04 00:00:00.000
print(DateTime.parse('2020-01-02 07')); // 2020-01-02 07:00:00.000
print(DateTime.parse('2020-01-02T07')); // 2020-01-02 07:00:00.000
print(DateTime.parse('2020-01-02T07:12')); // 2020-01-02 07:12:00.000
print(DateTime.parse('2020-01-02T07:12:50')); // 2020-01-02 07:12:50.000
print(DateTime.parse('2020-01-02T07:12:50Z')); // 2020-01-02 07:12:50.000Z
print(DateTime.parse('2020-01-02T07:12:50+07')); // 2020-01-02 00:12:50.000Z
print(DateTime.parse('2020-01-02T07:12:50+0700')); // 2020-01-02 00:12:50.00
print(DateTime.parse('2020-01-02T07:12:50+07:00')); // 2020-01-02 00:12:50.00
xxxxxxxxxx
DateTime.newInstance(myDate.year(), myDate.month(), myDate.day()).format('MY_FORMAT_STRING');
xxxxxxxxxx
-- 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 grepper