timezone conversion in SELECT query

[magiruuvelvet]

This might be useful in the future.

Retrieve the timezone offset from UTC.

#include <iostream>
#include <chrono>
#include <ctime>

int main()
{
    std::time_t now = std::time(nullptr);
    std::tm local_time = *std::localtime(&now);
    int offset_minutes = local_time.tm_gmtoff / 60;
    std::cout << "Timezone offset from UTC: " << offset_minutes << " minutes." << std::endl;
    return 0;
}

Perform timezone conversion directly from a SELECT statement.

fmt::format("select datetime(timestamp, 'unixepoch', '{}{} minutes')", offset < 0 ? '-' : '+', offset);