This article or section needs expansion.
SELECT YourUtcColumn AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time' AS LocalTime FROM YourTable The full list of timezone names can be found with: SELECT. FROM sys.timezoneinfo And yes, the timezones are badly named - even though it is Eastern Standard Time, daylight savings is taken into account. Time Zone Converter – Time Difference Calculator. Provides time zone conversions taking into account Daylight Saving Time (DST), local time zone and accepts present, past, or future dates. Determine your local time offset from UTC time. To do this, follow these steps on a Microsoft Windows-based computer: Click Start, click Run, type timedate.cpl, and then click OK. Click the Time Zone tab, and then verify that your local time zone is selected. Convert UTC to EST time zone, calculate the time difference between Universal Time (UTC/GMT) and Eastern Standard Time (North America) (EST).
In an operating system, the time (clock) is determined by four parts: time value, whether it is local time or UTC or something else, time zone, and Daylight Saving Time (DST) if applicable. This article explains what they are and how to read/set them. Two clocks are present on systems: a hardware clock and a system clock which are also detailed in this article.
Standard behavior of most operating systems is:
- Set the system clock from the hardware clock on boot.
- Keep accurate time of the system clock, see #Time synchronization.
- Set the hardware clock from the system clock on shutdown.
The hardware clock (a.k.a. the Real Time Clock (RTC) or CMOS clock) stores the values of: Year, Month, Day, Hour, Minute, and Seconds. Only 2016, or later, UEFI firmware has the ability to store the timezone, and whether DST is used.
Read hardware clock
Set hardware clock from system clock
The following sets the hardware clock from the system clock. Additionally it updates
/etc/adjtime or creates it if not present. See hwclock(8) section 'The Adjtime File' for more information on this file as well as the #Time skew section.
The system clock (a.k.a. the software clock) keeps track of: time, time zone, and DST if applicable. It is calculated by the Linux kernel as the number of seconds since midnight January 1st 1970, UTC. The initial value of the system clock is calculated from the hardware clock, dependent on the contents of
/etc/adjtime. After boot-up has completed, the system clock runs independently of the hardware clock. The Linux kernel keeps track of the system clock by counting timer interrupts.
To check the current system clock time (presented both in local time and UTC) as well as the RTC (hardware clock):
Set system clock
To set the local time of the system clock directly:
sets the time to May 26th, year 2014, 11:13 and 54 seconds.
There are two time standards: localtime and Coordinated Universal Time (UTC). The localtime standard is dependent on the current time zone, while UTC is the global time standard and is independent of time zone values. Though conceptually different, UTC is also known as GMT (Greenwich Mean Time).
The standard used by the hardware clock (CMOS clock, the BIOS time) is set by the operating system. By default, Windows uses localtime, macOS uses UTC, and UNIX-like systems vary. An OS that uses the UTC standard will generally consider the hardware clock as UTC and make an adjustment to it to set the OS time at boot according to the time zone.
If multiple operating systems are installed on a machine, they will all derive the current time from the same hardware clock: it is recommended to adopt a unique standard for the hardware clock to avoid conflicts across systems and set it to UTC. Otherwise, if the hardware clock is set to localtime, more than one operating system may adjust it after a DST change for example, thus resulting in an over-correction; problems may also arise when traveling between different time zones and using one of the operating systems to reset the system/hardware clock.
The hardware clock can be queried and set with the
timedatectl command. You can see the current hardware clock time standard of the Arch system using:
To change the hardware clock time standard to localtime, use:
To revert to the hardware clock being in UTC, type:
/etc/adjtime automatically and update the RTC accordingly; no further configuration is required.
During kernel startup, at the point when the RTC driver is loaded, the system clock may be set from the hardware clock. Whether this occurs depends on the hardware platform, the version of the kernel and kernel build options. If this does occur, at this point in the boot sequence, the hardware clock time is assumed to be UTC and the value of
/sys/class/rtc/rtcN/hctosys (N=0,1,2,..) will be set to 1.
Later, the system clock is set again from the hardware clock by systemd, dependent on values in
/etc/adjtime. Hence, having the hardware clock using localtime may cause some unexpected behavior during the boot sequence; e.g system time going backwards, which is always a bad idea (there is a lot more to it). To avoid it systemd will only synchronize back, if the hardware clock is set to UTC and keep the kernel uninformed about the local timezone. As a consequence timestamps on a FAT filesystem touched by the Linux system will be in UTC.
- The use of
timedatectlrequires an active dbus. Therefore, it may not be possible to use this command under a chroot (such as during installation). In these cases, you can revert back to the hwclock command.
/etc/adjtimeis not present, systemd assumes the hardware clock is set to UTC.
UTC in Microsoft Windows
To dual boot with Windows it is recommended to configure Windows to use UTC, rather than Linux to use localtime. (Windows by default uses localtime .)
It can be done by a simple registry fix: Open
regedit and add a
DWORD value with hexadecimal value
1 to the registry:
You can do this from an Administrator Command Prompt running:
Alternatively, create a
*.reg file (on the desktop) with the following content and double-click it to import it into registry:
Should Windows ask to update the clock due to DST changes, let it. It will leave the clock in UTC as expected, only correcting the displayed time.
The #Hardware clock and #System clock time may need to be updated after setting this value.
If you are having issues with the offset of the time, try reinstalling tzdata and then setting your time zone again:
For really old Windows, the above method fails, due to Windows bugs. More precisely,
- For 64-bit versions of Windows 7 and older builds of Windows 10, there was a bug that made it necessary to have a
QWORDvalue with hexadecimal value of
1instead of a
DWORDvalue. This bug has been fixed in newer builds and now only
- Before Vista SP2, there is a bug that resets the clock to localtime after resuming from the suspend/hibernation state.
- For XP and older, there is a bug related to the daylight saving time. See  for details.
- For even older versions of Windows, you might want to read https://www.cl.cam.ac.uk/~mgk25/mswish/ut-rtc.html - the functionality was not even documented nor officially supported then.
For these operating systems, it is recommended to use localtime.
UTC in Ubuntu
Ubuntu and its derivatives have the hardware clock set to be interpreted as in 'localtime' if Windows was detected on any disk during Ubuntu installation. This is apparently done deliberately to allow new Linux users to try out Ubuntu on their Windows computers without editing the registry.
For changing this behavior, see above.
To check the current zone defined for the system:
To list available zones:
To set your time zone:
This will create an
/etc/localtime symlink that points to a zoneinfo file under
/usr/share/zoneinfo/. In case you choose to create the link manually (for example during chroot where
timedatectl will not work), keep in mind that it must be a symbolic link, as specified in archlinux(7)[dead link 2021-02-08]:
See timedatectl(1), localtime(5) and archlinux(7)[dead link 2021-02-08] for details.
Setting based on geolocation
To set the timezone automatically based on the IP address location, one can use a geolocation API to retrieve the timezone, for example
curl https://ipapi.co/timezone, and pass the output to
timedatectl set-timezone for automatic setting. Some geo-IP APIs that provide free or partly free services are listed below:
Update timezone every time NetworkManager connects to a network
Create a NetworkManager dispatcher script:
Alternatively, the tool tzupdateAUR automatically sets the timezone based on the geolocation of the IP address. This comparison of the most popular IP geolocation apis may be helpful in deciding which API to use in production.
Every clock has a value that differs from real time (the best representation of which being International Atomic Time); no clock is perfect. A quartz-based electronic clock keeps imperfect time, but maintains a consistent inaccuracy. This base 'inaccuracy' is known as 'time skew' or 'time drift'.
When the hardware clock is set with
hwclock, a new drift value is calculated in seconds per day. The drift value is calculated by using the difference between the new value set and the hardware clock value just before the set, taking into account the value of the previous drift value and the last time the hardware clock was set. The new drift value and the time when the clock was set is written to the file
/etc/adjtime overwriting the previous values. The hardware clock can therefore be adjusted for drift when the command
hwclock --adjust is run; this also occurs on shutdown but only if the
hwclock daemon is enabled, hence for Arch systems which use systemd, this does not happen.
hwclockconsiders the elapsed time period too short to accurately calculate the drift.
If the hardware clock keeps losing or gaining time in large increments, it is possible that an invalid drift has been recorded (but only applicable, if the hwclock daemon is running). This can happen if you have set the hardware clock time incorrectly or your time standard is not synchronized with a Windows or macOS install. The drift value can be removed by first removing the file
/etc/adjtime, then setting the correct hardware clock and system clock time. You should then check if your time standard is correct.
/etc/adjtimeeven when using systemd, (e.g. you cannot or do not want to use NTP), you must call
hwclock --adjuston a regular basis, perhaps by creating a cron job.
The software clock is very accurate but like most clocks is not perfectly accurate and will drift as well. Though rarely, the system clock can lose accuracy if the kernel skips interrupts. There are some tools to improve software clock accuracy:
- See #Time synchronization.
The Network Time Protocol (NTP) is a protocol for synchronizing the clocks of computer systems over packet-switched, variable-latency data networks. The following are implementations of NTP available for Arch Linux:
- Chrony — A client and server that is roaming friendly and designed specifically for systems that are not online all the time.
- https://chrony.tuxfamily.org/ chrony
- ConnMan — A lightweight network manager with NTP support.
- https://01.org/connman connman
- Network Time Protocol daemon — The reference implementation of the protocol, especially recommended to be used on time servers. It can also adjust the interrupt frequency and the number of ticks per second to decrease system clock drift, and will cause the hardware clock to be re-synchronised every 11 minutes.
- http://www.ntp.org/ ntp
- ntpclient — A simple command-line NTP client.
- http://doolittle.icarus.com/ntpclient/ ntpclientAUR
Utc To Local Time Zone
- NTPsec — A fork of NTPd, focused on security.
- https://ntpsec.org/ ntpsecAUR
- OpenNTPD — Part of the OpenBSD project and implements both a client and a server.
- http://www.openntpd.org/ openntpd
- sntp — An SNTP client that comes with NTPd. It supersedes ntpdate and is recommended in non-server environments.
Utc To Local Time Python
- http://www.ntp.org/ ntp
- systemd-timesyncd — A simple SNTP daemon that only implements a client side, focusing only on querying time from one remote server. It should be more than appropriate for most installations.
Utc To Local Time Conversion Chart
- https://www.freedesktop.org/wiki/Software/systemd/ systemd
Per-user/session or temporary settings
For some use cases it may be useful to change the time settings without touching the global system values. For example to test applications relying on the time during development or adjusting the system time zone when logging into a server remotely from another zone.
To make an application 'see' a different date/time than the system one, you can use the faketime (from libfaketime) utility.
If instead you want an application to 'see' a different time zone than the system one, set the
TZenvironment variable, for example:
This is different than just setting the time, as for example it allows to test the behavior of a program with positive or negative UTC offset values, or the effects of DST changes when developing on systems in a non-DST time zone.
Another use case is having different time zones set for different users of the same system: this can be accomplished by setting the
TZ variable in the shell's configuration file, see Environment variables#Defining variables.
Clock shows a value that is neither UTC nor local time
This might be caused by a number of reasons. For example, if your hardware clock is running on local time, but
timedatectl is set to assume it is in UTC, the result would be that your timezone's offset to UTC effectively gets applied twice, resulting in wrong values for your local time and UTC.
To force your clock to the correct time, and to also write the correct UTC to your hardware clock, follow these steps:
- Setup ntpd (enabling it as a service is not necessary).
- Set your time zone correctly.
ntpd -qgto manually synchronize your clock with the network, ignoring large deviations between local UTC and network UTC.
hwclock --systohcto write the current software UTC time to the hardware clock.
Tips and tricks
alarm-fake-hwclock designed especially for system without battery backed up RTC, it includes a systemd service which on shutdown saves the current time and on startup restores the saved time, thus avoiding strange time travel errors.
Installfake-hwclock-gitAUR, start and enable the service
Utc To Local Time C#
- Sources for Time Zone and Daylight Saving Time Data for tzdata
Microsoft uses Coordinated Universal Time (UTC) format, an international standard 24-hour timekeeping system, to document the created dates and times of files that are included in a software update. This article describes how to convert UTC to local time to verify that the file that is on your computer is the one that is discussed in the documentation.
To convert UTC to local time, follow these steps:
Determine your local time offset from UTC time. To do this, follow these steps on a Microsoft Windows-based computer:
Click Start, click Run, type timedate.cpl, and then click OK.
Click the Time Zone tab, and then verify that your local time zone is selected. If your local time zone is not selected, click it in the list of available time zones.
The local time offset is shown at the start of each local region list item. For example, -5:00 is the local time offset for Eastern Time (US & Canada):
(GMT-5:00) Eastern Time (US & Canada)
Add the local time offset to the UTC time.
For example, if your local time offset is -5:00, and if the UTC time is shown as 11:00, add -5 to 11. The time setting when adjusted for offset is 06:00 (6:00 A.M.).
Note The date also follows UTC format. For example, if your local time offset is -8:00, and if the file's UTC time is shown as 00:00 (12:00 midnight) on Monday, the adjusted time is 16:00 on Sunday (4:00 P.M., Sunday).
Adjust for daylight saving time.
UTC time is not adjusted to reflect daylight-saving time. If your time zone participates in daylight saving time, add the time difference to the file's offset-adjusted time when daylight saving time is in effect. For example, if daylight saving time in your time zone is one hour ahead of standard time, add one hour to the offset-adjusted time.
Convert the 24-hour time format to 12-hour time format if your local time uses the 12-hour format. To make the conversion, follow these steps:
If the offset-adjusted time is between 12:01 and 23:59, inclusive, subtract 12 from the adjusted time, and then append P.M.
If the adjusted time is between 00:01 and 11:59, inclusive, leave the adjusted time as is, and then append A.M.
If the adjusted time is 00:00, use 12:00 midnight.
If the adjusted time is 12:00, use 12:00 noon.
Utc To Local Online
You can use this method to compare the file's converted time to the time of a software update file that is on your computer.
When you view the file details of the file that is on your computer, the date in the Date Modified column may be different from the date in the Date Created column. If this difference occurs, use the date in the Date Modified column.