this post was submitted on 28 Oct 2025

874 points (99.0% liked)

Programmer Humor

27248 readers

872 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

anzo@programming.dev

Feyter@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

874

Days since last timezone issue (lemmy.ml)

submitted 1 week ago by cm0002@lemmings.world to c/programmer_humor@programming.dev

21 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] moseschrute@lemmy.world 2 points 1 week ago

I agree, storing in a consistent unit is the way. That doesn’t solve conversion/rounding issues, but it does simplify things.

Though you can run into floating point errors when editing in one unit vs storing in another. For example, maybe the user entered 2 in unit A, then it’s converted to unit B and stored in the db. However, when it’s converted back to unit A, it’s 1.999999. Fortunately rounding fixes this. We say unit A and B get 2 decimals of precision, and 1.999999 becomes 2.00.