Date/Time Strings

[minimaxir]

Making note to add date/time strings which can trick up naive date/time parsers:

• non-US date/time formats (e.g. 2017.01.16)
• Illegal dates/times (e.g. 2017-01-32 26:00)
• Leap Day on non-leap year (e.g. 2017-02-29)
• Timezones/illegal timezones

Reference: Wikipedia, xkcd

[Y-Less]

Leap seconds, like 31/12/16 23:59:60 (also another non-US date format).

[mjustin]

I think I've seen "0/0/1900" used as a null date, and Google says that "1/0/1900" is how Excel displays 0 as a date.

[joedragons]

Does this make https://github.com/minimaxir/big-list-of-naughty-strings/issues/55 obsolete? Or at least the answer to it "yes?"=)

[designgrill]

Not every divisible by 4 year is a leap year. 2100 will not be and 1900 wasn't. It might help to include corresponding dates.

[ColorXJH]

sorry，i've learn java for a short time,so i don't know what's the mean about it, I think I need a teachers

[rmunn]

Also:

• Dates that are valid in DD/MM/YYYY format but invalid in MM/DD/YYYY format, to catch any naive programmers who assumed that the rest of the world functions just like the US. E.g., 25/12/2000.
• Dates that catch people who thought the Julian calendar system was still in effect. E.g., 1900-02-29.

And if you want to get ESPECIALLY tricky:

• Dates that really WERE valid in one specific country, but would be totally invalid normally. E.g., 1712-02-30. See http://nodatime.org/1.3.x/userguide/trivia and https://www.timeanddate.com/date/february-30.html for more details.

[ColorXJH]

thanks so much

[ColorXJH]

thank you so much ------------------ 原始邮件 ------------------ 发件人: "Robin Munn";[email protected]; 发送时间: 2017年2月27日(星期一) 下午4:36 收件人: "minimaxir/big-list-of-naughty-strings"[email protected]; 抄送: "夏金辉"[email protected]; "Comment"[email protected]; 主题: Re: [minimaxir/big-list-of-naughty-strings] Date/Time Strings (#117)

Also:

Dates that are valid in DD/MM/YYYY format but invalid in MM/DD/YYYY format, to catch any naive programmers who assumed that the rest of the world functions just like the US. E.g., 25/12/2000.

Dates that catch people who thought the Julian calendar system was still in effect. E.g., 1900-02-29.

And if you want to get ESPECIALLY tricky:

Dates that really WERE valid in one specific country, but would be totally invalid normally. E.g., 1712-02-30. See http://nodatime.org/1.3.x/userguide/trivia and https://www.timeanddate.com/date/february-30.html for more details.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[ColorXJH]

may i make friends with u? i think u are pretty good and i want learn to u.

------------------ 原始邮件 ------------------ 发件人: "Robin Munn";[email protected]; 发送时间: 2017年2月27日(星期一) 下午4:36 收件人: "minimaxir/big-list-of-naughty-strings"[email protected]; 抄送: "夏金辉"[email protected]; "Comment"[email protected]; 主题: Re: [minimaxir/big-list-of-naughty-strings] Date/Time Strings (#117)

Also:

Dates that are valid in DD/MM/YYYY format but invalid in MM/DD/YYYY format, to catch any naive programmers who assumed that the rest of the world functions just like the US. E.g., 25/12/2000.

Dates that catch people who thought the Julian calendar system was still in effect. E.g., 1900-02-29.

And if you want to get ESPECIALLY tricky:

Dates that really WERE valid in one specific country, but would be totally invalid normally. E.g., 1712-02-30. See http://nodatime.org/1.3.x/userguide/trivia and https://www.timeanddate.com/date/february-30.html for more details.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[grandpabop]

How high are you

[ColorXJH]

I'm just a vegetable...maybe even more ,but how I talk with u? I just a Chinese boy ,have u used QQ?

发自我的 iPhone

在 2017年2月28日，20:27，grandpabop [email protected] 写道：

How high are you — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[ssokolow]

@ColorXJH This is not an appropriate type of conversation for this thread. In fact, attempting personal conversations and asking to move to QQ is so off-topic for a GitHub Issues thread that many projects will ban you.

I suggest you explore the world of programming-related IRC channels instead. (And be sure to read any rules listed or linked in each channel's topic line.)

[ColorXJH]

@ssokolow thank you very much

[rogerdc]

Moving things from #153 to here and closing #153.

Valid Date, Time, and DateTime formats: January 23, 2016 23 JAN 2016 23 JAN 16 23-JAN-2016 23 January 2016 ... Jan. 23, 2016

00:00:00 00:00:00 AM 12:00:00 AM 12:00:00 PM 23:59:59.997 12:00:00 18:48:42 ... 7:48 pm

January 23, 2016 12:00 am 23/1/16 14:54 ... 20160123T000000

Invalid dates/times: February 29, 2017 26:84:94 14:00 pm