'How can I convert unix timestamp into a CET & CEST timestamp without using ADD_DATE in FROM_UNIXTIME?

FROM_UNIXTIME returns GMT time. Due to the day light saving concept, I am forced to modify my query as I wrote below.

This is just an example of query, how I convert the unix time into CET time or CEST time.

SELECT order_id,
    date_created,
    DATE_ADD(FROM_UNIXTIME(date_created), INTERVAL 2 hour) AS "CEST Time",
    DATE_ADD(FROM_UNIXTIME(date_created), INTERVAL 1 hour) AS "CET Time"
FROM orders;

Is there any other way to do this effectively?

mysqltimezone


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions