News for hackers. Stuff that matters.
Re:How and why the Relational Model works for databases by AtlasBarfed on Monday January 17, 2022 @12:23PM (#29968934)
So you don't like serialized java dates, which presumably are some standard at least.

You don't like longs / epoch.

So..... what do you like?

Date formatting/conversion/serialization is not standardized across databases. And it's generally hair pulling (at least the Oracle version was last I checked which was a long time ago).

Longs or ISO-8601 strings? No DB-specific crud. Yes please.

Re:How and why the Relational Model works for databases by forinti on Tuesday January 18, 2022 @06:13AM (#29977568)
At least you can compare longs and index them. That's not too bad. But I prefer to just use the native date type; it allows you to use the built-in date functions.