Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [timestamp]

The time at which an event is recorded by a computer.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

How Can LibreOffice Convert Milliseconds To Timestamp Or DateTime?

In LibreOffice I had converted timestamps into milliseconds because I didn't find a built-in way to naturally handle a standard time format. But now for real people, I want to convert that time easily ...
Zach's user avatar
  • 103
1 vote
1 answer
50 views

linux last status change time / last modification time

When I modify the content of a file, for example by date > f.txt then I execute stat f.txt I see that both last status change time and last modification time are both are changed. I am looking for ...
tahzibi.jafar's user avatar
0 votes
1 answer
77 views

Excel - how to handle custom timestamp format

I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this: 12.04.2024 15:11:32:684 12.04.2024 15:11:35:752 The format of this is: dd.mm....
blrgblrgblrg's user avatar
3 votes
1 answer
513 views

How can all files on my drive suddenly have modified timestamps set to 1 hour newer than a week ago?

I regularly back up most of my files using Robocopy using the mirror function. I haven't noticed anything odd in the past days, since I most frequently backup to another SSD. But to my horror, when ...
Hunnicatt's user avatar
1 vote
0 answers
64 views

How to extract subtitle timestamps using ffprobe (not working as expected)?

I am trying to extract subtitle timestamps from a M2TS file using ffprobe. This does not work as expected. The M2TS file is known to contain 1001 subtitles in track 4, but I am getting about 4000 ...
Binarus's user avatar
  • 1,805
2 votes
1 answer
138 views

Multiple Interfaces on same subnet breaks PTP

I have a PC ("main PC") with two interfaces mgbe0 and mgbe1. Both of these interfaces connect to another PCs A and B (mgbe0->"A", mbge1->"B"). Both PCs A and B are ...
Megapiot's user avatar
1 vote
1 answer
251 views

dir /ta for displaying last-access times sometimes shows last-write times instead

On my Windows 11 22H2 system, I've verified that that last-access timestamps are maintained (fsutil behavior query disableLastAccess), and in PowerShell they can be retrieved. However, with cmd.exe's ...
mklement0's user avatar
  • 2,080
0 votes
1 answer
200 views

Excel: the first and last time per day

I have an Excel file with timestamps and I want to find the first and last time per day, My spreadsheet has thousands of rows, but here is an extract: Startup Time Shutdown Time 29.10.2020 15:59 29....
Joao's user avatar
  • 1
26 votes
2 answers
5k views

What is this 14-digit time format from Windows registry?

Microsoft Office 365 saves information in the registry about what time it last searched/downloaded/applied updates in a format like this: Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\office\ClickToRun\...
Cpt.Whale's user avatar
  • 7,944
0 votes
0 answers
3k views

Manually alter/change displayed time and date sent Outlook email? Alter headers date time sent in code Outlook

In Gmail I can go in using inspect and dev tools and epoch converter then go through SMTP and alter the date and time stamps, backdate emails, send custom fillable dynamic emails. I can’t find ...
Ellie Sjogren's user avatar
1 vote
1 answer
121 views

how to test in bash which of the two symlinks is older (or newer)

Apparently, the bash tests -nt and -ot dereference links. Let's consider the following files and links to them: $ ls -lt --full-time f* | cut -d ' ' -f 6- 2023-04-24 02:05:01.083919712 +0200 f1l -> ...
user avatar
1 vote
0 answers
129 views

influxDB v1.8 : InfluxQL : Continous Query in a bash script

I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
6a5h4's user avatar
  • 11
1 vote
1 answer
70 views

How to set old modification times between the working directory and its backup recursively?

Let's assume you have two directories, e.g., /long_path_1 and /long_path_2 (potentially with spaces), that you know to be almost equal, e.g., because you previously ran diff -rq --no-dereferences /...
user avatar
1 vote
0 answers
31 views

Auto Timsetamp formula is extending but not calculating correct/Today's date

=IF([@Code1]<>"",IF([@[Auto DT]]<>"",[@[Auto DT]],NOW()),"") This formula to get timestamp in column [Auto DT]. Currently Step1 = I add code in new row. New ...
Danish's user avatar
  • 11
0 votes
1 answer
81 views

How to get a timestamp from DCR (Digital Court Room) player into a Word processor?

I'd like to be able to get the current playing time of a file in DCR media player and insert it as a timestamp into a word processor (e.g., Microsoft Word).Therefore, something like a macro button can ...
7hcl5's user avatar
  • 1
0 votes
1 answer
126 views

Auto Update Date & Timestamp in a specific cell irrespective of any data range (With or Without VBA)?

Would anyone be able to help me with this issue? I have data based on the categories (as per spent) in specific columns & cells, i.e., C4:C25, F4:F25, I4:I10. However, I want the "Updated ...
sushil rai's user avatar
3 votes
1 answer
582 views

ts - timestamp input utility: setting time zone for time stamps

Under the ENVIRONMENT section man page for ts [ts(1)] reads: The standard TZ environment variable controls what time zone dates are assumed to be in, if a timezone is not specified as part of the ...
mikeskk's user avatar
  • 33
0 votes
0 answers
82 views

Enter timestamp in a cell when a dropdown box in another cell is updated (no VBA)

I need to enter a timestamp in a cell when a dropdown box in another cell is updated. This is for a live In/Out board spreadsheet, so apparently I cannot use macros. Right now I have the formula set ...
Niffermama's user avatar
2 votes
1 answer
2k views

Timestamp (date/time) system used by LibreOffice Calc / OpenOffice Calc spreadsheet applications?

What system does LibreOffice Calc / OpenOffice Calc use to represent timestamps (dates/times) as numbers? It's apparent that they don't use the standard integer epoch times that are common in computer ...
End Antisemitic Hate's user avatar
1 vote
0 answers
641 views

PowerShell script to copy files and iterate them depending on name and timestamp

Let me start by saying, I really don't know powershell. I am an pharma process automation engineer so my experience is programming PLCs and HMI design. I have written all sorts of languages but I am ...
sam's user avatar
  • 21
2 votes
1 answer
2k views

In PowerShell, how to save a DateTime variable into a file to be retrieved later?

I want to log the timestamp when a certain line is executed so that the script can know how long it has passed since last execution of that line, even if the script is stopped in between and the ...
user167420's user avatar
0 votes
1 answer
8k views

journalctl timpestamp format

journalctl -S [timestamp] So journalctl prints out a lot of info, as those reading this probably already know. There is a flag -S (or --since) that allows the user to pinpoint the date of the logs she ...
JΛYDΞV's user avatar
  • 896
4 votes
3 answers
4k views

Is there a way to tell the WinMerge to exclude date/time comparison?

I have several log files with content like this: 2022-03-13 21:16:46.367972: I This is a test1 Is there a way to tell the WinMerge to exclude date/time comparison without removing a timestamp with a ...
Andrey's user avatar
  • 151
1 vote
0 answers
55 views

Moving or Copying files from one NAS to another while maintaining Timestamps

Some of our designers want to move some of their old files from our active Synology unit to an archive Synology unit using their windows machines. But it is imperative all the timestamps (created, ...
Albert H's user avatar
0 votes
2 answers
2k views

Simple Bluetooth device monitor with timestamps

I have a Raspberry Pi whatever (yes, with BT) and I'd like it to function as a very simple Bluetooth monitor which records beacons/nearby-device-ids/whatevers that it hears about in a big long text ...
psoft's user avatar
  • 265
0 votes
0 answers
292 views

way to globally add timestamps to terminal output?

I am trying to find a way to have all terminal output from .ksh scripts to have a time stamp pre-pended to the beginning of the line. The challenge is, the scripts I want to add these time stamps to ...
Matt Curry's user avatar
0 votes
0 answers
1k views

Photos' timestamps get changed (to when they're moved onto new phone, and their creation date gets set to 1969 - losing all order of images

Scenario: New Android 11 cell phone. Moving 1000's of photos over from old Android 5 phone via a 64bit Win8.1 PC. Photos on new phone then all adopt creation a time stamp of 12.31.1969 (no clue why) ...
Peter's user avatar
  • 1
1 vote
1 answer
1k views

What do we call this line in video editing?

This might be an obvious question but I can't seem to find the answer to it. What do we call the line highlighted in yellow?
user1644371's user avatar
1 vote
1 answer
1k views

Timestamp changes when copying file to exFAT drive

I am using Windows 10 and i formatted my USB pen drive as exFAT. Then I copied a file with modification timestamp 22:57:46 to the pen drive and the it stays the same (the date doesn't matter). Then I ...
zomega's user avatar
  • 1,250
1 vote
1 answer
494 views

Plotting Non-Contiguous Time Onto a Chart in Excel

I was given a spreadsheet with dates and timestamps of when one of our systems went down and came back up with the task of creating a visualization of the data. The Date and Timestamps were embedded ...
Jordan's user avatar
  • 37
1 vote
1 answer
775 views

How is it possible that the "created" timestamp for a file is later than the "last modified" one?

I discovered this while looking at the file properties in File Explorer in Windows 10 for some old .wav sound files I recorded using my voice with a microphone using Audacity and never modified since. ...
Clenon Cowham's user avatar
1 vote
1 answer
2k views

How to batch convert PNGs to JPEGs and preserve timestamps in filesystem & EXIF header?

I sometimes take screenshots on my Mac during video-calls with friends/family (with their consent of course!) and would like to add those images of a photographic nature to my Apple Photos Library. I ...
porg's user avatar
  • 369
0 votes
0 answers
195 views

Windows' command return dates in 2066?

On our Windows 10 Entreprise LTSC 10.0.17763 systems, if I run: cscript c:\windows\system32\slmgr.vbs /dlv | findstr "Trusted Time: I get timestamps in 2066!, e.g. 1/17/2066 4:28:53 AM. I have ...
HASM's user avatar
  • 143
0 votes
0 answers
844 views

How to sort the results of a find command by the last access time?

I find all the PDF files using find . -type f -name *.pdf How can I sort the files in the results by the last access time, and then by the last modification time? By access time, I mean the time when ...
qazwsx's user avatar
  • 8,969
0 votes
2 answers
99 views

How to highlight trends in time records? (system errors)

I have a list of system error timestamps. I want to graph the time from the timestamps to see if there are any trends -- i.e. approximate times of day when the system often goes down. Question: Is ...
User1974's user avatar
  • 147
0 votes
1 answer
462 views

AIDE "atime in future" Warnings

I am on a Debian 10 virtualbox guest test sever and I am trying to configure AIDE. However, I keep receiving a warning message saying: root@tester1:~# aide -c /etc/aide/aide.conf --check / atime in ...
mjones's user avatar
  • 317
1 vote
1 answer
31 views

Is MacBook Pro timestamp of pictures 100% accurate?

A few months ago I let my housemate use my computer for a zoom class while I was out at work. I told her the password and since I trusted her I thought she would use it only for that purpose and day. ...
Maria's user avatar
  • 11
1 vote
2 answers
1k views

Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"

I have a column of timestamps (strings) formatted like so: This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM I'm trying to get them to be formatted into dates but Excel refuses for ...
Alex McLean's user avatar
0 votes
0 answers
69 views

Change Date stamp to just Month and Year

I found this simple code to copy my files and paste them into a new folder and label it with the current MMDDYYYY. I'm trying now to get it to just give me the month and year (Ex. March 2021). @Echo ...
mnrandrews's user avatar
2 votes
1 answer
5k views

How to sort registry entries by last write time/last modified time in PowerShell

I am learning PowerShell, I use PSCore7.1 on Windows 10 20H2, currently I can do this: Get-ChildItem -Path "C:\" -Directory -Recurse -Depth 5 | Where-Object{$_.LastWriteTime.ToString("...
Ξένη Γήινος's user avatar
0 votes
1 answer
3k views

Usage of "-timestamp now" in ffmpeg

I'm new to ffmpeg and I'd like to ask if anyone know how to use "-timestamp now" in ffmpeg. https://stackoverflow.com/questions/12293853/how-to-use-ffmpeg-timestamp-syntax said that the ...
carl trevor's user avatar
2 votes
1 answer
770 views

FFMpeg Segment MP4 Negative Audio PTS

I'm trying to split an mp4 file into segments and each segment should start with near to zero a/v pts. I'm also re-encoding the mp4 file for different bitrates. This is the command I used; ffmpeg -i &...
user3533414's user avatar
0 votes
0 answers
75 views

Determine file system of a copied file from file timestamp log

I've got a log file (.csv) that lists folders and files and various dates of every record on a hard drive, including: Std Info Creation date, Std Info Modification date, Std Info Access date, Std ...
Serowsky's user avatar
1 vote
1 answer
8k views

Lightest way to add timestamps in Notepad++?

What is the lightest way to add a timestamp string within a Notepad++ text document? The method I know of is to use a plugin that gives Notepad++ Python functionality, and then write a small Python ...
End Antisemitic Hate's user avatar
1 vote
1 answer
2k views

FFmpeg: audio start time way off

Real-time audio and video is recorded from one audio source and two video sources: ffmpeg -y -copyts \ -f pulse -thread_queue_size 1024 -i alsa_input.usb-Focusrite_Scarlett_2i2_USB_Y8CAJW2063E5BD-00....
Lasse Kliemann's user avatar
2 votes
1 answer
1k views

How to include the milliseconds in Outlook “received” time? (hh:mm:ss)

What is the formula to see milliseconds. Previous post shows how to add seconds but need more detail. Here is the formula from other post - Format([Received],"ddd yyyy-mm-dd hh:mm:ss")
Michael Guerra's user avatar
0 votes
0 answers
256 views

Always show full time stamp in Thunderbird

I would like to always show the full timestamp for messages in Thunderbird (eg in the inbox). The default settings only shows the time if the email came in the same day: Does anyone know the setting ...
Albin's user avatar
  • 10.8k
0 votes
1 answer
927 views

How do I convert strange timestamp into date format in excel?

I have this strange timestamp in an Excel spreadsheet, e.g. 2020-09-07 00:00:00.0 This is UK, so it's YYYY-MM-DD How can I get Excel 2013 to see this as 07/09/2020 DD/MM/YYYY? Thanks
user2390698's user avatar
0 votes
1 answer
46 views

Danger/Liability Concerns for Filestamp Editing Tool [closed]

Admin at my company are wanting a timestamp editing tool to make bulk edits to some Word documents (in Windows 10) on our shared drives and I'm tasked with assessing tools from a usability and "...
Alice Greene's user avatar
0 votes
2 answers
298 views

Does VMware Workstation Update Timestamps on Unchanged VMDK Files?

I'm looking into solutions for backing up virtual machines and I was wondering if anyone can confirm how VMware Workstation handles timestamps on vmdk files. If I'm using a vmdk drive split into ...
Harry Muscle's user avatar

1
2 3 4 5