Questions tagged [utc]
The utc tag has no usage guidance.
28
questions
1
vote
2
answers
193
views
EXIFTOOL, track creation date, and timezone
I am trying to make sense of the QuickTime/TrackCreateDate value obtained for a file created by camera recording on an iPhone 15, latest OS. In this case, I was in Japan at the time. According to ...
3
votes
1
answer
22k
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, ...
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 ...
1
vote
0
answers
330
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 ...
0
votes
2
answers
1k
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 ...
1
vote
2
answers
518
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 ...
8
votes
3
answers
87k
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 ...
0
votes
1
answer
564
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 ...
0
votes
0
answers
307
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 ...
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?
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,...
108
votes
2
answers
168k
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 ...
0
votes
1
answer
87
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 :
...
49
votes
4
answers
34k
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 ...
1
vote
3
answers
792
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 ...
2
votes
1
answer
185
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 ...
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 ...
2
votes
0
answers
714
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 ...
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\...
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 ...
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 ...
1
vote
1
answer
656
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 ...
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?
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 ...
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 ...
92
votes
3
answers
97k
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 ...
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\...
2
votes
2
answers
2k
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 ...