Why TimeZone and leap periods are such a pain
Posted by jpluimers on 2020/01/30
A cautionary tale on time zones, and the big warning on using a unix timestamp (only 18 years to go on that one…)
–jeroen
https://www.youtube.com/watch?v=QJQ691PTKsA
The Wiert Corner – irregular stream of stuff
Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests
-
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy Subscribe
Archives
- October 2026 (36)
- September 2026 (45)
- August 2026 (42)
- July 2026 (46)
- June 2026 (46)
- May 2026 (42)
- April 2026 (45)
- March 2026 (45)
- February 2026 (47)
- January 2026 (48)
- December 2025 (54)
- November 2025 (47)
- October 2025 (50)
- September 2025 (49)
- August 2025 (47)
- July 2025 (50)
- June 2025 (47)
- May 2025 (48)
- April 2025 (46)
- March 2025 (44)
- February 2025 (48)
- January 2025 (55)
- December 2024 (48)
- November 2024 (44)
- October 2024 (51)
- September 2024 (46)
- August 2024 (53)
- July 2024 (50)
- June 2024 (36)
- May 2024 (33)
- April 2024 (33)
- March 2024 (36)
- February 2024 (28)
- January 2024 (28)
- December 2023 (27)
- November 2023 (24)
- October 2023 (24)
- September 2023 (29)
- August 2023 (31)
- July 2023 (33)
- June 2023 (26)
- May 2023 (26)
- April 2023 (31)
- March 2023 (26)
- February 2023 (27)
- January 2023 (24)
- December 2022 (33)
- November 2022 (27)
- October 2022 (23)
- September 2022 (25)
- August 2022 (24)
- July 2022 (26)
- June 2022 (26)
- May 2022 (23)
- April 2022 (32)
- March 2022 (69)
- February 2022 (63)
- January 2022 (66)
- December 2021 (75)
- November 2021 (66)
- October 2021 (64)
- September 2021 (67)
- August 2021 (69)
- July 2021 (69)
- June 2021 (69)
- May 2021 (68)
- April 2021 (67)
- March 2021 (72)
- February 2021 (63)
- January 2021 (65)
- December 2020 (70)
- November 2020 (64)
- October 2020 (68)
- September 2020 (67)
- August 2020 (67)
- July 2020 (71)
- June 2020 (68)
- May 2020 (64)
- April 2020 (67)
- March 2020 (70)
- February 2020 (61)
- January 2020 (74)
- December 2019 (70)
- November 2019 (63)
- October 2019 (73)
- September 2019 (68)
- August 2019 (66)
- July 2019 (68)
- June 2019 (68)
- May 2019 (72)
- April 2019 (73)
- March 2019 (64)
- February 2019 (68)
- January 2019 (78)
- December 2018 (87)
- November 2018 (77)
- October 2018 (79)
- September 2018 (77)
- August 2018 (76)
- July 2018 (74)
- June 2018 (63)
- May 2018 (70)
- April 2018 (63)
- March 2018 (72)
- February 2018 (48)
- January 2018 (83)
- December 2017 (67)
- November 2017 (62)
- October 2017 (63)
- September 2017 (52)
- August 2017 (62)
- July 2017 (48)
- June 2017 (57)
- May 2017 (68)
- April 2017 (55)
- March 2017 (59)
- February 2017 (58)
- January 2017 (60)
- December 2016 (59)
- November 2016 (74)
- October 2016 (61)
- September 2016 (87)
- August 2016 (57)
- July 2016 (51)
- June 2016 (49)
- May 2016 (48)
- April 2016 (51)
- March 2016 (49)
- February 2016 (50)
- January 2016 (48)
- December 2015 (59)
- November 2015 (57)
- October 2015 (37)
- September 2015 (31)
- August 2015 (41)
- July 2015 (31)
- June 2015 (37)
- May 2015 (30)
- April 2015 (32)
- March 2015 (37)
- February 2015 (52)
- January 2015 (50)
- December 2014 (43)
- November 2014 (39)
- October 2014 (40)
- September 2014 (41)
- August 2014 (58)
- July 2014 (32)
- June 2014 (23)
- May 2014 (38)
- April 2014 (105)
- March 2014 (145)
- February 2014 (81)
- January 2014 (56)
- December 2013 (58)
- November 2013 (32)
- October 2013 (26)
- September 2013 (26)
- August 2013 (54)
- July 2013 (47)
- June 2013 (41)
- May 2013 (33)
- April 2013 (41)
- March 2013 (50)
- February 2013 (47)
- January 2013 (55)
- December 2012 (32)
- November 2012 (23)
- October 2012 (37)
- September 2012 (52)
- August 2012 (46)
- July 2012 (40)
- June 2012 (30)
- May 2012 (27)
- April 2012 (30)
- March 2012 (29)
- February 2012 (32)
- January 2012 (25)
- December 2011 (38)
- November 2011 (28)
- October 2011 (46)
- September 2011 (63)
- August 2011 (35)
- July 2011 (24)
- June 2011 (24)
- May 2011 (24)
- April 2011 (29)
- March 2011 (50)
- February 2011 (48)
- January 2011 (18)
- December 2010 (5)
- November 2010 (18)
- October 2010 (22)
- September 2010 (29)
- August 2010 (24)
- July 2010 (27)
- June 2010 (29)
- May 2010 (25)
- April 2010 (23)
- March 2010 (10)
- February 2010 (6)
- January 2010 (16)
- December 2009 (12)
- November 2009 (3)
- October 2009 (11)
- September 2009 (21)
- August 2009 (11)
- July 2009 (11)
- June 2009 (5)
- May 2009 (12)
- April 2009 (20)
Category Cloud
*nix *nix-tools .NET About Apple C# Conferences Conference Topics Delphi Development Event Google Hardware Hardware Development History Internet LifeHacker Linux Mac OS X / OS X / MacOS Personal Power User Scripting Security SocialMedia Software Development Source Code Management VMware Web Development Windows Windows 7Recent Comments
-
Recent Posts
- On my wish list – BLE caberQU: a digital USB-C to USB-C cable tester
- Chronotrains: maps where can you go by train in 8h (or less) from any European city (for instance from Amsterdam)
- GitHub – kiesraad/abacus: Abacus, software voor verkiezingsuitslagen en zetelverdeling
- Hacking IKEA – Raspberry Pi: make Vindriktning IoT and put it on the internet
- There are two kinds of mastofeeds?! Some notes and ideas.
Blog Stats
- 3,744,437 hits
Meta title
Tag Cloud Title
.NET Framework 000000 0000ff 1 2 2 factor authentication 3 3d 3dprint 3dprinting 3m 4 4K Monitor 4K Ultra HD 5 6 7 7z 7zip 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 23a 24 24 hours 25 26 27 29 30th Anniversary Edition 32 35 37 42 48 52 55 61 73 75 76 000080 88 91 96 101 103 128 138 143 156 159 162 172 195 205 233 237 254 258 305 309 325 339 374 379 394 425 561 594 600 640 738 763 768 769 787 938 981 1010 1018 1029 1054 1509 1644 1656 1686 1779 1915 1971 2020 2021 2023 2062 2084 2100 2141 2142 2209 2502 2767 2850 2852 2977 3042 3277 4261 4640 4689 5053 5155 5531 6493 7473 7476 008000 008080 8846 11078 11281 12306 13296 15073 17427 18365 19100 21771 21962 22537 22728 23311 25827 27651 32392 33188 35690 36566 44201 46843 48558 48559 51505 97720 97790 100422 3088938 a11y accessibility access violation account settings acpi Adest Musica administrative privileges adobe font adobe software adt AI AirBnB airline alliances Alexandre GOUAILLARD Allen Bauer AllesIstKaput american inventor amstelland analyser android Android emulator Android SDK AndroidSystemSafetyCore annual report antarctic region Apple appleii appleiigs apple macbook Apple Support Communities apple technology application version Appril april 1st AprilApples architecture art arts assembler version assembly instructions assembly language astronaut asus attendees audio codec audio fragment august 1st autogas aviation Avondshow babyfur backslash banks bassdrum batch file batch files battery life bbc news BBC Radio 4 Extra bigdata bitbucket BLM blog blog entry blogging blong bmp file bmw bmwe60 bmwe61 bmwtips bollenstreek booking flights borland borland C++ borstkanker bot broderbund browser vendor bufferbloat Buffer Overflow bugs BuiltOnAspNetCore burgernet business business passengers ByeAmazon c7 C64 ca certificate ca certificates Caps Lock cars cat5e c builder certificate authority CES2025 change ChatGPT cheat code checkm8 Chromebook Classic Typewriters climate Cloudflare clustercomputing cnet reviews cng stations code monkey coeffects colour distribution colour palettes comedy comics command-line commandline arguments command line tools Commodore Commodore64 comparison operators component market compressed natural gas computer computer history museum computer network computing computing hardware conclusion Conferences ConfigParser Consumerist cornucopia Covid CovidIsNotOver CppBuilder CPU usage CPU utilization cray documentation cray machines CreativeCoding cross platform c runtime library crying csharp CSS syntax elements c style ctrl c cURL cybergangster CyberSecurity cyberwarrior dak Darkmeta data binding datacenter date formats David M Williams day trips ddns Debugging DEC DeepSeek default gateway default routes DEFCON30 define de jager delegate Delphi delphi 1 delphi 5 delphi 6 delphi applications Delphi book delphi code Delphi Component Design delphi conferences Delphi Cookbook delphi developers delphi ide delphi language Delphi Pipe delphi team delphi tips Delphi TParser Delphi versions DelphiWeek dementie Democracy denial of service attack departure airport departure date Deployment Manager design design time desktop apps desktop environment desktop interface deuren DevDays09 developer development environment DevOps DFIR Dilbert dinvoke disaster recovery plan div DIY DMARC DNS documentation domains domain validation dos vulnerability dotnet dotnetcore doug engelbart douglas engelbart download delphi Draw! drawing drive bays drive mapping DropBox dsl adsl duet duurzaamheid dynamic dns service düsseldorf germany early november ECC RAM eco system edge data edit editor buffer editors education eerlijkecloud eham ekon EKON20 electronic invoices electronics elektronica else email provider embarcadero EMERGENCY mode empty parameter endif endregion energy density engineering engineering team english versions enterprise-it environment environment variables error 500 error messages excerpt excessive CPU usage execcommand executionPlan exercism exitscam expired certificate ExploratoryTesting f5f8fa facebook fake certificates FBPE Feedly ff0000 ffffff fiber Fiddler file formats financial domain find fingers finger touch firmware updates firstpost flickr flight duration floppydiskfriday fmx focus folder structure foley font design fonts forum gps foryou foryoupage free chapters Free Pascal FreePascal free starter free WiFi french english translations fritz box full name full script text funny fyp gadgets gaming garmin geekporn geeks germany austria germany switzerland GExperts gigabyte GitHub GitLab glasvezel glenn crouch gmail gmail account GnuTLS google Google Authenticator google cache GoogleCloudFunctions Google Hangouts google images google maps google search goto cleanup GoToWebinar gps devices graph greatscott great stuff hacking hamradio Hangouts Hangouts Dialer happy new year hard drive hardlinks hardware version hardware versions hash collision hashtable hd HDD hdds hdpe Heartbleed heidelberg germany helper monkeys HelpMessages hetsyndroomvanmoeje hex key hidden files hidden gems hinvoke Hitachi drives hittegolf homelab Hosting hotel business hotfixes houd HPC HTML HEAD tag huissen human interface guidelines iata airport codes ibm websphere mq ICC ide ideas if ikea imperial units include inclusion inclusive inconvenience index names Infocom infosec innovation innovatorsplus integration system intel intel 8086 intel assembly Intel Communities Intel HD graphics intel mcs InterBase interface types internet internet explorer patch internet explorer versions internet rfc investering iOS iOS6 iOS development ip address change iphone iphone 5 iso 8601 iso calendar ISupportExercism James Friend java jre java runtime environment java script code java security java updates java version java vulnerability jeroen JFokus jitter JSON julian Junction Points kennemerland keyboard keyboard layout keyboard shortcuts kg Kieswijzer kpn4all Kristian Köhntopp lame landmarks language reference guide latency LaTeX laughedanyway layout engine left pane leiden leidsch dagblad Length function lenovo thinkpad light blue touchpaper line breaks Linux liquefied petroleum gas listeners Logical operators logitech mouse lowest fare m3u Mac macbook MacDrive Mac emulator machine hardware macintosh developers mac os x mac programmer mac rumors maintenance releases major features maldev map map drive Maps marc hoffman MarkDown marketing Mashable meaningful name measurement units Media megabytes member search member type Meme memoryforensics memory manager memory managers memory modules memprocfs Mercurial meshcore message box messages metric Metropolis Michael Panzer micro focus micron technology inc microsoft microsoft com downloads microsoft office microsoft office online microsoft patches microsoft security bulletin microsoft surface microsoft windows mid 1980s migration MikroTik Milan Linate airport mobile modula 2 mono mp4 msbuild Multi-Device munten Music nasm nat friedman nature NeoSmart nerdjoke netneutraliteit networkbasics network connections networking networks networks4hackers Neuland new features new java new option NewProfilePic newyear new year Nick Butcher nick hodges nicolette nikkor nikon nintendo nes nl nmap noodkanaal notebook hdd notifications NPPSPY NTFS NTFS file system NTLM authentication ObjectPascal object pascal object windows library ocw odd office excel office microsoft Oma Omdenken opensource open source openSUSE OpenWRT operator overloading opus OS os x OS X 10.8 Mountain Lion OSXDaily outdoors oververhitting owc Oxygene Packt paper bins paradise Paragon NTFS ParodyMusicVideo party software pascal path names pcb pc computing PCE pc hardware pcx pdf pentest Pentesting percussion perl phone photography physical ram pingbot plastic playlists Play Services pleonasm pls Polizeiakademie possible power button PowerShell ppp precaution preferred airline preferred airlines presentations Privacy Productivity product portfolio professional edition ProgrammerHumor programmers guide Protagio Pro Tips proudof public appearances Push notifications Python query quest mode quotes radiation therapy RADStudio rangers RareAesthetic RaspberryPi ray lischner ready to assemble furniture real world reboot recommended reading Recovery Pending redteam region regression regular expressions reimtsich relative paths Reload remap Rene Larsen repair repositories research result results resultSets retina retro retrogaming right tools ring tone room key route change route print RouterOS routers rpi rsync rtl nieuws Ruby run samsung sarcasme sas scheduling schulenansnetz science scott hanselman screw script secure software security alert security fixes securitynl Select selfhost SepTandy serverbuilds Server Fault set severity rating shareholder shellacces shorts Showband Adest Musica shutdown button SIM cards site sizes smartphones Smurfwijzer snapshots snippets Sn_blackmeta Sn_darkmeta social-media software software company software development software engineering software glitches software products soldaat van oranje sound soundeffects sourcecode language sourceforge Southport Spaces speed improvement spread knowledge SQL SQLite SQL Server SQL Server 2012 SQL Server Management Studio 2012 ssd ssd drives ssl certificate ssl connections stablediffusion stack overflow stat StaySafe stem Stemwijzer streams subnetting summer holiday SUSE sweet spot switch symbolic links system preferences system shutdown T-Mobile USA tb Tech Blast TechCrunch technology teleconverter telfort temporal compatibility terminal emulator terminal session test text The Hitchhiker's Guide to the Galaxy the Boot Camp Support Software thinkpad this ThisIsWhyWeCantHaveNiceThings thread work tierney timeline timer resolution tiny tips tips and tricks TK2023 TK2025 TLS todays software toegankelijkheid toner tool Toshiba touch monitor touch windows transportation Travel Travel More Efficient tray menu truckrun TTY turbo assembler turbo pascal 6 Turbo Pascal era tutor twitter Typography tyvek envelopes ui Ukraine ultimate hack UniDAC unique visitors unproductive days Update Installation url usb3 USBArmyKnife user interface UXdesign VALUE VAXXED vcl Verkiezingen Verkiezingen2023 verona italy version compatibility version number vertical lines vintagecomputing vintagegaming viral virtual disk virtual hardware virtualization virtual machine virtual machines virtual machine systems VLB vm vms VMware VMware Fusion VMware Workstation vr Warren Postma web browsers web editors web fonts webm Welcome2021 wget wget speedfan WhyCantWeHaveNiceThings WIDM wieisdemol wieisdemol2025 WiFi wikipedia Wil van Kesteren windows controls Windows keyboard windows keyboard shortcuts windows phone Windows Server 2003 R2 windows shortcuts Windows Update Windows XP Windows XP SP2 wonderful magazine wordpress workout x86 processors XE8 xkcd XML xs4all Yahoo Yahoo Pipes Zeer bedroefd hebben wij kennis genomen van het overlijden van Oma Wil van Kesteren zero day zero results ZFS zookeepersTop Clicks
Top Posts
- When NTFS shrink fails, despite using the default settings from the shrink dialog
- Is this the ultimate XKCD "Dependency" derivative?
- Technical Debt - Dilbert Comic Strip on 2017-01-03 | Dilbert by Scott Adams
- Factory reset a MikroTik hEX PoE RB960PGS using the reset button
- Calls from +18553308653 might be because someone is trying to use your phone number to setup a Microsoft account two factor authentication
- C13/C14 wiring diagram live/neutral/earth
- Hacking IKEA - Raspberry Pi: make Vindriktning IoT and put it on the internet
- LIDL Radio Controlled Wall Clock IAN 100489 English manual
- Database fiddle sites
- delphi - How to have both VCL and FMX in one application? - Stack Overflow
My badges
Twitter Updates
Tweets by jpluimersMy Flickr Stream
Pages
All categories
Email Subscription
Join 716 other subscribers
Leave a Comment