53°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • Aaron Parecki
    🤯 TIL MySQL is aware of daylight savings time, and considers any times between 2am-3am when the clocks skip forward an invalid date!

    In one session, it might throw an error, and in another session, it might store 3:00am instead of 2:05! 🤯
    Portland, Oregon, USA • 46°F
    #mysql #time
    Sat, Mar 11, 2023 7:08pm -08:00
    27 likes 2 reposts 12 replies
    • ⛧Satanist⛧
    • Ethan
    • V
    • Kushal Dave
    • Stephan
    • Jace
    • Johannes Ernst
    • Omer Preminger
    • Chuck Grimmett
    • colhountech
    • Frank L. Morales II
    • Aaron Francis
    • Daniel ⚡️
    • Ankur Kumar
    • Muhammad Bilal
    • Nerdy Momo Cat
    • Zephyr
    • Raphaël T-M
    • Andrew Turner (@ajturner@nullisland.social)
    • Mark
    • Kieran Benton
    • Steve Harms
    • @mteu@phpc.social
    • Armin
    • Adam
    • Raul Jimenez Ortega
    • Justin Richer 🐀
    • Stephan Graf
    • Captain Macho Pirate Mick Rackham.yarr🏴‍☠️
    • Andrew Turner (@ajturner@nullisland.social) twitter.com/ajturner
      Posted! twitter.com/ajturner/statu…
      Mon, Mar 13, 2023 8:53pm +00:00 (via brid.gy)
    • Andrew Turner (@ajturner@nullisland.social) twitter.com/ajturner
      MySQL, one of the most popular databases across the world used in commercial and consumer software systems, has erratic DST behavior. h/t @aaronpk
      Mon, Mar 13, 2023 8:53pm +00:00 (via brid.gy)
    • Aaron Parecki twitter.com/aaronpk
      Nice, I look forward to reading it!
      Sun, Mar 12, 2023 7:53pm +00:00 (via brid.gy)
    • Michael Gaigg twitter.com/MichaelGaigg
      All I know is that I lost my Sunday morning soccer
      Sun, Mar 12, 2023 7:22pm +00:00 (via brid.gy)
    • Andrew Turner (@ajturner@nullisland.social) twitter.com/ajturner
      Thanks for the example. I’m writing a blog post about the hidden costs of DST changes
      Sun, Mar 12, 2023 6:57pm +00:00 (via brid.gy)
    • zorn micro.blog/zorn

      @aaronpk Nightmare fuel.

      Sun, Mar 12, 2023 4:37pm +00:00
    • V_ micro.blog/V_

      @aaronpk that sounds like a nice to happen bug report you can waste so much time on it when you don't know about it.

      Sun, Mar 12, 2023 8:29am +00:00
    • Thomas Cantrell twitter.com/thomas_cantrell
      Sun, Mar 12, 2023 4:24am +00:00 (via brid.gy)
    • Aaron Parecki twitter.com/aaronpk
      oh no
      Sun, Mar 12, 2023 4:12am +00:00 (via brid.gy)
    • Thomas Cantrell twitter.com/thomas_cantrell
      Now do leap seconds!
      Sun, Mar 12, 2023 4:07am +00:00 (via brid.gy)
    • Aaron Parecki aaronparecki.com
      omfg, TIMESTAMP type columns are timezone-aware, but DATETIME columns are always UTC. How have I been using MySQL for 25 years and never known this

      https://dev.mysql.com/doc/refman/8.0/en/datetime.html
      Sat, Mar 11, 2023 7:15pm -08:00
    • 👨‍👩‍👧‍👦 Bret 🏜️🚙 twitter.com/bcomnes
      Database is closed, try again in the morning.
      Sun, Mar 12, 2023 3:09am +00:00 (via brid.gy)
Posted in /notes using quill.p3k.io

Hi, I'm Aaron Parecki, Senior Security Architect at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming and dabble in product design.

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Security Architect at Okta
  • IndieWebCamp Founder
  • OAuth WG Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2023 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv