The SQL used to manage dates and times varies by database type. The code to generate this SQL (e.g., DATE_FORMAT() or FROM_UNIXTIME()) has historically been handled by modules that work with dates and times, wrapped in long switch statements to handle the officially supported databases. (more or less.) A d.o issue raised the possibility of a date abstraction API, but nothing ever came of it.
Similar to #2888, this is code that was created to support PostgreSQL in Silkscreen and is submitted here because the non-PostgreSQL part of the patch is valid for Backdrop, even if all it accomplishes is better encapsulation of database code in the database classes.
Unlike #2888 and #2889, this is a little more invasive, changing the date_sql_handler class in the Date module, and several Views handlers.
As with #2888, I'm submitting this because I consider it good open source etiquette to provide patches to parent projects, even if the patch's true purpose cannot be realized upstream, in this case database independence.
Recent comments
I recently ran into the same error: Exception: The configuration directory in settings.php is specified as 'files/config_[some-random-CMI-ID-here]/active', but this...
Live deployment Configuration Directory error
https://github.com/shabib-m/tailwindcss/wiki
Free Backdrop Theme built on Tailwind CSS v3 (Based on Basis) - Seeking Feedback & Ideas!
Admin Edit - note the image above is a link to the YouTube video.
Free Backdrop Theme built on Tailwind CSS v3 (Based on Basis) - Seeking Feedback & Ideas!