> ## Documentation Index
> Fetch the complete documentation index at: https://kb.hosting.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Converting the MySQL time zone

> Learn to convert time zones in MySQL using the CONVERT_TZ function with this concise guide featuring instructions, code snippets, and related articles.

This article describes how to convert the time zone in MySQL by using the **CONVERT\_TZ** function.

## Using the CONVERT\_TZ function

By default, hosting.com servers use one of the following time zones:

* US-based (Michigan) servers: US Eastern Time zone.

* Europe-based (Amsterdam) servers: Central European Time zone.

* Asia-based (Singapore) servers: Singapore Standard Time zone.

On shared servers, you cannot change the default MySQL time zone, because this would affect other accounts on the server. However, you can convert the time zone used in **DATE**,**TIME**, and **DATETIME** fields by calling the **CONVERT\_TZ** function as needed.

For example, the following sample query shows how to convert the current date and time in the US Eastern time zone to the time zone for Paris, France:

```sql theme={null}
SELECT CONVERT_TZ( NOW(),'US/Eastern','Europe/Paris' );
```

<Tip>
  For a complete list of time zones, please visit [https://en.wikipedia.org/wiki/List\_of\_tz\_database\_time\_zones](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones).
</Tip>

## More information

* For more information about time zone support in MySQL, please visit [http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html](http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html).

* For more information about the **CONVERT\_TZ** function, please visit [http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function\_convert-tz](http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_convert-tz).

## Related articles

* [Connecting to MySQL from the command line](/docs/connect-to-mysql-from-the-command-line)

* [Converting a MySQL database to UTF-8](/docs/convert-mysql-database-utf-8)

* [Changing the time zone on a managed hosting account](/docs/changing-the-time-zone-on-a-managed-hosting-account)

* [Managing MySQL databases, users, and tables from the command line](/docs/managing-mysql-databases-and-users-from-the-command-line)

* [Changing the time zone in the Linux shell](/docs/changing-the-time-zone-in-the-linux-shell)

* [Changing the time zone in webmail](/docs/changing-the-time-zone-in-webmail)