Questions tagged [timestamp]
The time at which an event is recorded by a computer.
215
questions
1
vote
1
answer
54
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 -> ...
- 33
1
vote
0
answers
29
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 ...
- 11
1
vote
1
answer
59
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 /...
- 33
1
vote
0
answers
26
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 ...
- 11
0
votes
1
answer
51
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 ...
- 1
0
votes
1
answer
72
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 ...
0
votes
0
answers
122
views
Saving and Restoring File TimeStamps (Created, Modified and Accessed) for files in folders with sub-folders
I'm running on Windows.
I know that WinRAR has the option to save and restore all file dates/times (Created, Modified and Accessed) but I need to archive some files (including files in sub-folders) ...
- 1
2
votes
1
answer
159
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 ...
- 23
0
votes
0
answers
17
views
Timestamp not functioning properly
I have created an In/Out board for the company I work for. I have a dropdown box for users to choose their availability type and I would like the "Last Update" column to update with the ...
0
votes
0
answers
30
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 ...
2
votes
1
answer
549
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 ...
1
vote
0
answers
403
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 ...
- 21
2
votes
1
answer
973
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 ...
- 182
0
votes
1
answer
2k
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 ...
- 568
2
votes
3
answers
2k
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 ...
- 131
1
vote
0
answers
32
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, ...
- 11
0
votes
1
answer
538
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 ...
- 263
0
votes
0
answers
143
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 ...
0
votes
0
answers
551
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) ...
- 1
1
vote
1
answer
448
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?
- 13
1
vote
1
answer
763
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 ...
- 1,234
1
vote
1
answer
217
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 ...
- 37
1
vote
1
answer
253
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.
...
1
vote
1
answer
1k
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 ...
- 327
0
votes
0
answers
139
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 ...
- 143
0
votes
0
answers
482
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 ...
- 8,439
0
votes
2
answers
66
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 ...
- 137
0
votes
1
answer
292
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 ...
- 267
1
vote
1
answer
23
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. ...
- 11
1
vote
2
answers
558
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 ...
- 115
0
votes
0
answers
29
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 ...
2
votes
1
answer
3k
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("...
- 2,665
0
votes
1
answer
2k
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 ...
2
votes
1
answer
490
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 &...
- 23
0
votes
0
answers
54
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 ...
- 1
0
votes
1
answer
5k
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 ...
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....
- 228
2
votes
1
answer
814
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")
0
votes
0
answers
105
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 ...
- 9,089
0
votes
1
answer
647
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
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 "...
- 13
0
votes
2
answers
250
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 ...
- 101
0
votes
2
answers
232
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
...
- 3
0
votes
0
answers
33
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 ...
- 11
3
votes
2
answers
12k
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.
0
votes
0
answers
2k
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 ...
- 141
1
vote
1
answer
483
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 ...
- 111
1
vote
1
answer
140
views
All files and folders on my Macbook Air now have year 2018 in their timestamp
Somewhere last year, all files and folders on my Mac suddenly started displaying "2018" as their creation and modification year. This happened in Finder but also in the photo app Picasa. Day and month ...
- 21
4
votes
1
answer
16k
views
Want timestamp in CMD for every command
So, I have opened a Windows CMD and I am running one build script command in it. Problem is, sometimes(honestly, often) I forget to run this build script after doing changes in my code. If there was ...
- 153
0
votes
1
answer
2k
views
How to group timestamp in the format yyyy-MM-dd'T'HH:mm:ssZZZZ into buckets of 15 minutes in excel?
I need to find the number of records (pid) in the interval (buckets) of 15 minutes for a year long data. Normally when MM/DD/YY H:MM AM, you just pivot the data, put timestamp into row, click on group ...
