SQL - CURRENT_TIMEZONE() Function

---

---

The SQL CURRENT_TIMEZONE() function is used to return the current time zone offset from Coordinated Universal Time (UTC) based on the system time zone where the SQL server is running.

The time zone offset is the difference between the local time and the UTC, represents in hours and minutes.

This function returns the time zone offset in the format of ‘+/- HH:MM’, where a positive (+) sign specifies an offset ahead of UTC, and a negative (-) sign specifies an offset behind UTC.

Note − In SQL, the timezone is always set to UTC and CURRENT_TIMEZONE function returns the name of the UTC time zone.

Syntax

Following is the syntax of the SQL CURRENT_TIMEZONE() function −

CURRENT_TIMEZONE()

Parameters

This function does not accept any parameters.

Example

The following example demonstrates the usage of the CURRENT_TIMEZONE() function −

SQL> SELECT CURRENT_TIMEZONE() AS CURRENT_TIMEZONE;

Output

When we execute the above query, the output is obtained as follows −

+--------------------------------------------------+
| CURRENT_TIMEZONE                                 | 
+--------------------------------------------------+
| (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi  |
+--------------------------------------------------+

Example

Assume we have created a table with the name STUDENTS in the SQL database using the CREATE statement as shown in the query below −

SQL> CREATE TABLE STUDENTS(ID INT NOT NULL, NAME VARCHAR (200) NOT NULL, AGE INT NOT NULL);

Now, let us insert some records in the STUDENTS table using INSERT statements as shown in the query below −

SQL> INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(1, 'Dhruv', '20');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(2, 'Arjun', '23');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(3, 'Dev', '25');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(4, 'Riya', '19');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(5, 'Aarohi','24');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(6, 'Lisa', '20');
INSERT INTO STUDENTS(ID, NAME, AGE) VALUES(7, 'Roy', '24');

We can verify whether the table is created or not using the following query −

SQL> SELECT * FROM STUDENTS;

The table STUDENTS is successfully created in the SQL database.

+----+--------+-----+
| ID | NAME   | AGE |
+----+--------+-----+
| 1  | Dhruv  | 20  |
| 2  | Arjun  | 23  |
| 3  | Dev    | 25  |
| 4  | Riya   | 19  | 
| 5  | Aarohi | 24  |
| 6  | Lisa   | 20  | 
| 7  | Roy    | 24  |
+----+--------+-----+

We can retrieve the current time zone of the students using the following query −

SQL> SELECT *, CURRENT_TIMEZONE() AS CURRENT_TIMEZONE FROM STUDENTS;

Output

The output for the above query is produced as given below −

+----+--------+-----+-------------------------------------------------+
| ID | NAME   | AGE | CURRENT_TIMEZONE                                |
+----+--------+-----+-------------------------------------------------+
| 1  | Dhruv  | 20  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi |
| 2  | Arjun  | 23  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
| 3  | Dev    | 25  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
| 4  | Riya   | 19  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
| 5  | Aarohi | 24  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
| 6  | Lisa   | 20  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
| 7  | Roy    | 24  | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi | 
+----+--------+-----+-------------------------------------------------+