56°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • Aaron Parecki https://aaronparecki.com/   •   Mar 11
    🤯 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! 🤯
    Aaron Parecki
    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
    Portland, Oregon, USA • 46°F
    Sat, Mar 11, 2023 7:15pm -08:00
    26 likes 1 repost 5 replies
    • ⛧Satanist⛧
    • Joël Franusic
    • Tyler Sticka
    • Ethan
    • Christophe
    • Greg Kamprath
    • Kushal Dave
    • Daniel Brahneborg, PhD 🇸🇪
    • Jace
    • Johannes Ernst
    • benjamin melançon
    • Joel Bernstein
    • Suchit Agarwal
    • Farasath Ahamed
    • Frank L. Morales II
    • colhountech
    • Johan Bernhardsson
    • Aaron Francis
    • Ankur Kumar
    • Rasmus P
    • Zephyr
    • Armin
    • theswayambhu
    • Adam
    • Justin Richer 🐀
    • Aaron Francis twitter.com/aarondfrancis
      Boom, on it. I think I cover this in video three or four actually!
      Sun, Mar 12, 2023 2:33pm +00:00 (via brid.gy)
    • Daniel ⚡️ twitter.com/getDanArias
      cc @aarondfrancis @hollylawly 👀
      Sun, Mar 12, 2023 2:31pm +00:00 (via brid.gy)
    • colhountech twitter.com/colhountech
      Dates are hard. #Nodatime / #Jodatime
      Sun, Mar 12, 2023 3:52am +00:00 (via brid.gy)
    • Aaron Parecki twitter.com/aaronpk
      right???
      Sun, Mar 12, 2023 3:45am +00:00 (via brid.gy)
    • Jared twitter.com/thejjburden
      Wait, what!!!
      Sun, Mar 12, 2023 3:34am +00:00 (via brid.gy)
Posted in /replies using quill.p3k.io

Hi, I'm Aaron Parecki, Director of Identity Standards 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. (detailed bio)

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.

  • Director of Identity Standards at Okta
  • IndieWebCamp Founder
  • OAuth WG Editor
  • OpenID Board 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-2025 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