finding the server timezone using SQL

Question

I need to find the server timezone, in this form :

UTC: (SIGN)(HOURS):(MINUTES)

My code is :

SELECT 'UTC' || EXTRACT(TIMEZONE_HOURS FROM CURRENT_TIMESTAMP) || ':' || 
EXTRACT(TIMEZONE_MINUTE FROM CURRENT_TIMESTAMP) || '0' AS tz_offest;

But I am still missing the sign (+) or (-) , how can I put the sign?

I've guessed you may be asking about Oracle (you are clearly **not using MySQL**). If it isn't the case, please add the correct tag yourself. — Álvaro González, Apr 10 '17 at 16:36

score 0 · Answer 1 · edited May 23 '17 at 12:02

0

Try this

SELECT 
CONCAT(
    IF(TIMEDIFF(NOW(), UTC_TIMESTAMP) >= '00:00:00', '+', '-'),
    SUBSTR(TIMEDIFF(NOW(), CONVERT_TZ(NOW(), @@SESSION .time_zone, '+00:00')), 1, 5)
) AS timezone;

Reference answer from How do I get the current time zone of MySQL?

edited May 23 '17 at 12:02

Community

1
1

answered Apr 08 '17 at 06:10

Wajih

4,227
2
25
40

finding the server timezone using SQL

1 Answers1