Tips for handling timezones in Postgres

[@mehdi_sadeghi]

Dude, when you were teaching MySQL back then, I really wished you’d do Postgres. Now that it’s happening, I’m really happy!

[@aarondfrancis]

❤️ the universe conspired

[@MrZax-kl5si]

These videos are the best. Keep pumping this content Aaron

[@saryakan]

Best tip on handling time zones? Don't.

[@additionaddict5524]

aaron is the godfather

[@jrheaberlin]

What client are you using?

[@aarondfrancis]

TablePlus!

[@Voltra_]

My personal go-to is to store dates as UTC timestamps in the database, and parse the UTC timestamp on the client side (sometimes directly, or with Date.UTC). Oh, and to never manipulate timezones (or worse, offsets)

[@CodingWithTaaxo]

Hey Aaron, If you're still putting together that course, I'd be down if you could throw in a section on cron jobs. I'm learning Postgres, and your teaching style is the bomb. Can't wait to grab your course!

[@aarondfrancis]

Oh nice, added to my list!

[@dalcod]

That is a good suggestion.

[@nolocobralink]

is there a way to show the offset on the final date without having to change the time zone on the session? for example, I'm in the America/Santiago timezone (currently on daylight saving time), and a former colleague made a small application using Postgres as the db and set UTC as the overall time zone (not just in the db), if I use the REST API of the app to check the records, all the dates will be on UTC with the offset "+00", if I ever added a query parameter that allowed me to show all the dates on a specific time zone (in this case America/Santiago), how can I implement that without changing the time zone on the session and still get the offset? ("-04" or "-03" depending on daylight saving)

[@HashimWarren]

Is the course project based? Looking forward to it

[@codedusting]

Timezones of all things should have been a physics problem, not politics. How did that even happen?

[@aarondfrancis]

Geeze, I dunno. It sucks though

[@codedusting]

@@aarondfrancis yes. I had to make a real estate auction site for Dubai UAE but international buyers. It was quite hell back in 2020.

[@melvillespence6768]

Where do you set the origin? Greenwich was chosen in 1884 at the Meridian Conference, when the UK was the preeminent power. GMT was adopted within the UK in 1847 because of the railways. BST came in WW1 to make best use of the working day, in WW2 we had double summer time for the same reason. In an ideal world we would use 15 degrees of longitude = 1 hour, but 🤣

[@gilesbbb]

This is set up for covering special relativity in the next video, yes?

[@jricardoprog]

Comparing timestamp is also annoying in pg, I need to remove 1ms to find the same record

[@djasnive]

Since when did you use Postgres

[@aarondfrancis]

I'm a free agent now!

[@FrankGehann]

This was a really great sum up. Thank you very much!

[@sahaj.r]

Time stone 😄

[@dalcod]

October 15 is too far for me lol.

[@quintenkamphuis]

8:30 base because Docker haha

[@aarondfrancis]

haha I dont know what I was thinking

[@jrdnrc]

thanks i hate timezones

[@dnukeranged]

full course hype

[@aarondfrancis]

😮‍💨 it's coming so soon! I gotta hurry!

[@coffeeowl86]

Amazing content as always! I'm glad you're also covering Postgres. Best wishes 🤗 Update: I joined the wait list for the course :D

[@estebanmurcia8451]

6:42 guilty as charged

[@aarondfrancis]

gottem

[@luca4479]

What kind of camera do you use to film your videos? Your camera quality is on par with MKBHD and LTT, I’m in awe!

[@aarondfrancis]

Canon R6!

[@kirayamato6128]

Aaron ❤️🧡💛💚🩵💙💜🤎🖤🩶🤍🩷