Questions tagged [utc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
15k views

Excel - UTC to EST Formula

I have a UTC timestamp that looks like this in Excel: 2022-10-28T18:12:23.603Z I need the information to appear as 10/28/22 hh:mm:ss AM/PM format but I need it to come out in EST timezone. Right now, ...
Sheri Morgan's user avatar
0 votes
0 answers
21 views

WHat is wrong with gmt-5 and gtm+5 timezone files in linux [duplicate]

I am in EDT time zone and I would like to use GMT-5 to convert time to EST (GMT-5 and EST should be the same I think). But GMT-5 results in +5hr offset from UTC which I would expect GMT+5 should be ...
user3143318's user avatar
1 vote
0 answers
290 views

Windows Time Sync issues cmd.exe & svchost running

I have a strange issue that is happening with our time syncing error for a computer at work. Randomly the PC changes time to a year,few minutes, hours back. Example: before the glitch it will be ...
MrPeachyPenguin's user avatar
0 votes
2 answers
839 views

How can I remove the letters “UTC” from the time in a column of cells with date and time entries?

I have cells in a spreadsheet with the date and time in UTC (over a thousand of them). I want to remove the letters UTC as I need to import the document elsewhere and it doesn’t work with the letters ...
Eleopd's user avatar
  • 1
1 vote
2 answers
482 views

Changed UTC time dumps after reboot in Arch Linux

I use Arch Linux OS with Linux 5.4.61-1-lts kernel, x86-64. I noticed, that my UTC time is wrong: [tao@dc ~]$ timedatectl Local time: Sun 2020-08-30 12:15:41 EEST Universal ...
GeneralTao's user avatar
8 votes
3 answers
78k views

How to convert UTC to typical date format in Excel?

I have this UTC column called Timestamp. It looks like this. 2019-06-27T23:01:12.1024861Z How do I convert it so it looks like this in Excel? 06/27/2019 23:01:12 If there is a formula that would ...
Brigitte1Trick's user avatar
0 votes
1 answer
531 views

Debian still using UTC

/etc/localtime is a symlink to Budpaest /etc/timezone is Budapest root@server:~# cat /etc/adjtime LOCAL root@server:~# date Sun Aug 6 06:58:42 UTC 2017 So all my crons using UTC, how can I use ...
Patrik Laszlo's user avatar
0 votes
0 answers
265 views

Format Excel datetimes with fixed widths and typical software formats

How can Excel be used to format dates with fixed widths using formats typical to software applications (MySQL DATETIME format, ISO 8601, RFC3339)? While it would be "nice" to convert to UTC, I am ...
user1032531's user avatar
  • 1,651
0 votes
0 answers
68 views

Windows 8 is reseting time after set to UTC

I changed timezone like suggest in this answer But every hour Windows is reseting the time. I disabled sync from internet but the problem continues How can I solve that error?
gvd's user avatar
  • 183
2 votes
2 answers
2k views

exFAT file timestamps

I use external SD cards to backup important data on my PC. I typically use "Robocopy /mir /ndl" so that I get on the SD card a true picture of what's on the disk. Twice a year, when the clocks change,...
akis_t's user avatar
  • 21
107 votes
2 answers
164k views

Does Windows 10 support UTC as BIOS time?

EDIT 2015-SEP-30: Seems I actually ended up with localtime enabled in Linux somehow, probably as a consequence of a reinstall some time ago. I switched Linux to UTC and now my configuration seems to ...
Dylan's user avatar
  • 1,655
0 votes
1 answer
84 views

Do Windows 7 time zones work correctly?

As you see below, I changed the Windows clock time-zone from UTC +3:30 Tehran to UTC +1:00 Windhoek. As 3:30 - 1:00 = 2.30, I expect the time to change -2:30, But it change -1.30 : Before : After : ...
Jean's user avatar
  • 145
49 votes
4 answers
33k views

A Windows clock to show both UTC and local time?

I'm working on windows 7 x64 and searching for a way for a setting, or replacement app of, the tray clock (on the taskbar corner) to display both UTC (or GMT) and my local time. Cause: I read log ...
n611x007's user avatar
  • 6,406
1 vote
3 answers
781 views

Does Google Chrome have some primary key in its cookies database?

I am writing some scanner for Google Chrome cookies, as stored in a SQLite database. It also has an option to delete cookies, however I didn't find any ID field. The most similar is creation_utc, I ...
ST3's user avatar
  • 755
2 votes
1 answer
181 views

How to isolate why my system date is going crazy?

The date on my x86 machine is going crazy. When I boot, it's in 1980 (as expected since the CMOS battery is dead). So I NTP sync it with no problems. Some time later (within a few hours, and even ...
kmort's user avatar
  • 1,711
6 votes
1 answer
2k views

Windows 7 set to UTC RTC forcibly changes time

I really want to make Windows 7 understand that RTC in using UTC instead of local time. I found a solution, except for it does not play well with time synchronization. I have: Modified the registry ...
drdaeman's user avatar
  • 179
2 votes
0 answers
711 views

Ubuntu 12.04 x32 - Windows 7 Pro x64 dual boot - clock is wrong (UTC)

I have a problem with time when booting windows after linux. The reason is that Ubuntu saves hw clock as UTC but Windows 7 expects it to be saved as localtime. So Windows shows time that is one hour ...
darthcz's user avatar
  • 31
1 vote
0 answers
512 views

Windows 7 Time Keeps Changing by 5 hours

I currently have Windows 7 set to use UTC in the hardware clock using this registry hack: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\...
SirensOfTitan's user avatar
45 votes
2 answers
27k views

Does Windows 8 support UTC as BIOS time?

Is there any way to use Windows 8 with time in UTC in BIOS? I know there is a way to do it in Windows 7 (in this question: Does Windows 7 support UTC as BIOS time?), but this solution makes my system ...
Roren's user avatar
  • 553
2 votes
3 answers
1k views

Running Webapp on Mac in UTC (either changing MacBook timezone or tomcat timezone)

To run my web app, I need to set my timezone to UTC on my MacBook. I can do this temporarily by opening a Konsole and entering sudo ln -sf /usr/share/zoneinfo/UTC /etc/localtime However, my timezone ...
Andy A's user avatar
  • 121
1 vote
1 answer
654 views

Windows 7 wake from sleep and UTC?

I've been having problems with windows 7 waking from sleep after one minute or so on my laptop. I also have ArchLinux installed on this computer. A while back I tried a registry tweak to get windows ...
xthrd's user avatar
  • 113
8 votes
3 answers
72k views

How to change the date of Linux to UTC/GMT +1?

I need to change the date of my system. I'm running a Linux CentOS 5.6. # date +%Z UTC # date Thu Oct 6 11:42:45 UTC 2011 How do I change the hour to be UTC/GMT +1?
André's user avatar
  • 259
5 votes
1 answer
2k views

Set Windows to use system clock as UTC

While dual-booting Windows and Linux, Linux sets the system time to UTC, so Windows thinks it's midnight near mid-morning. Is there any other way to tell Windows to use UTC? I've seen the registry ...
Cajunluke's user avatar
  • 2,404
3 votes
2 answers
2k views

Windows computer keeps updating to UTC time

I have a new Dell computer running Windows 7 x64 (and no other OS). I live in Mountain Time, as my computer is aware (it says Mountain Time in the Date and Time window, from right-clicking on the ...
Daniel H's user avatar
  • 1,624
92 votes
3 answers
96k views

Does Windows 7 support UTC as BIOS time?

Since I live in Germany, my timezone is GMT+1 (or GMT+2 in the summertime period). Previous Windows versions were not able to have the hardware clock set to UTC, and the Windows time to the local ...
mru's user avatar
  • 1,098
3 votes
3 answers
8k views

Windows XP clock set incorrectly after resume from sleep

I dual boot Linux and Windows XP on my laptop. I added the following registry key in XP to support Universal Time from the BIOS: HKLM\SYSTEM\CurrentControlSet\Control\TimeZoneInformation\...
lajos's user avatar
  • 953
2 votes
2 answers
1k views

How do email servers handle timestamps?

I'm using Thunderbird as my email client to check a Gmail account. I get a lot of emails from family who are located in different time zones. Now, my emails don't arrive out of order, but the ...
Shane's user avatar
  • 987