MariaDB desperately needs functions corresponding to FROM_UNIXTIME() and UNIX_TIMESTAMP, but that work strictly in UTC - that is, a:
UTC_FROM_UNIXTIME() that returns a UTC date from a unix timestamp, and
UTC_UNIX_TIMESTAMP(dt) that treats dt as being in UTC.
This can be achieved already by doing a SET @@time_zone:='+00:00' before using the existing functions, but that is inconvenient if you also wish to use local times in the same query.
It's important because the conversion is not reliable in any timezone that has DST.
Programmers should be able to convert UTC datetimes to UNIX timestamps and back simply and easily, without the conversion breaking one hour out of every year in some locales, and without having to do anything to (or even think about!) session timezone settings.
Compare this statement, broken for an hour at the end of DST each year :
Assume LastModTime is a DATETIME field storing a UTC value...
With this fix for it:
This works... but seriously, waaay overcomplicated!!!
What we should be able to write instead:
Simple, clear, and no non-obvious once-per-year bugs relating to timezones!