The Real Date Format

not a shock honestly is it fractional seconds since unix epoch or smth no worse is it literally just YYYYMMDD as a float no. worse. how see this is work of glorious microsoft corporation of redmond washington your mistake was ever expecting them to be sensible the real format is ddddd.ttt where d is days since jan 1 1900 and t is fractionally how much of the day has passed wow

A chat conversation explains that a date format is not Unix time or YYYYMMDD represented as a float. The punchline is the bizarre Microsoft date serial format: days since January 1, 1900, followed by the fractional part of the day. It is sent as a reaction to absurd legacy software conventions and Microsoft date-format weirdness.

• @pokupkabitka / 42288 2024-06-27