Questions tagged [timestamp]

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

Filter by
Sorted by
Tagged with
2 votes
1 answer
99 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
156 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,025
0 votes
1 answer
164 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,566
0 votes
0 answers
2k 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
112 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
117 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
75 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
111 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
2 votes
1 answer
521 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
  • 23
0 votes
0 answers
59 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
1k 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 Anti-Semitic Hate's user avatar
1 vote
0 answers
611 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
6k 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
  • 868
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
51 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
1k 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
  • 263
0 votes
0 answers
259 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
916 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
411 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
666 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
186 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
778 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,849
0 votes
2 answers
88 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
  • 137
0 votes
1 answer
437 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
  • 307
1 vote
1 answer
30 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
66 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
720 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
65 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
7k 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 Anti-Semitic 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
238 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.4k
0 votes
1 answer
882 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
286 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
0 votes
2 answers
404 views

converting numbers into timecode in Excel

I have a column with a bunch of two 4 digits. 1354 1356 1402 1421 1431 1452 1532 1546 ... and so on I've been trying to convert these to look more like 13:54 ~ 13:56 14:02 ~ 14:21 14:31 ~ 14:52 ...
Gil Y.'s user avatar
  • 3
0 votes
0 answers
36 views

What tool can PRESERVES the dates - timestamp (access, modify, change) while moving files to another file system?

I have 3 of the shelve NAS. I believe they run Linux. I don’t know which file system they use. I access these NAS from Windows through SMB. I need to service them. Replace all hard drives. Copy ...
Bostjan's user avatar
  • 11
5 votes
3 answers
16k views

ffmpeg filter to add timestamp on video

I have a problem displaying the timer on the video. I have consulted a few examples, but it does not show success. Help me fix it.
Lea... FFmpeg's user avatar
0 votes
0 answers
3k views

Retrieving RTSP/RTP Timestamps

This is an update to my previous post. I am able to get the RTP timestamps by using ffmpeg and opencv currently, however, I am trying to actually get the timestamp at which the frame was captured. I ...
penguin's user avatar
  • 141
1 vote
1 answer
696 views

Start systemd service after internet clock

My systemd service starts at boot, and creates a log file with timestamps. However, as it is running in a device without real time clock (Raspberry), it writes some lines with wrong timestamps from ...
Daniel Viaño's user avatar

1
2 3 4 5