Questions tagged [timestamp]

A timestamp is the time at which an event is recorded by a computer system. The timestamp term may also refer to Unix Time or to the timestamp data type.

A timestamp is a sequence of characters, denoting the date and/or time at which a certain event occurred. A timestamp is the time at which an event is recorded by a computer, not the time of the event itself. In many cases, the difference may be inconsequential: the time at which an event is recorded by a timestamp (e.g., entered into a log file) should be very, very close to the time of the occurrence of the event recorded.

In some cases, a timestamp can be just the numbering of events, the use of a date_time format to store a timestamp is then not mandatory.

This data is usually presented in a consistent format, allowing for easy comparison of two different records and tracking progress over time; the practice of recording timestamps in a consistent manner along with the actual data is called timestamping.

Timestamps are typically used for logging events, in which case each event in a log is marked with a timestamp. In filesystems, timestamp may mean the stored date/time of creation or modification of a file.


Examples of timestamps

  • 2005-10-30 T 10:45 UTC
  • 2007-11-09 T 11:20 UTC
  • Sat Jul 23 02:16:57 2005
  • 1256953732

Standardization

ISO 8601 standardizes the representation of dates and times. These standard representations are often used to construct timestamp values.


References

13570 questions
4
votes
0 answers

Prometheus - how to retrieve first metrics timestamp

I am performing a query against some metric with a time range, say sum_over_time(my_metrics{my_filter=~"filter_regex"}[4d]) What I am looking for is a way to determine if returned metrics were available for all 4 days. I want to bypass all returned…
Łukasz
  • 1,980
  • 6
  • 32
  • 52
4
votes
2 answers

Timezone problem with jQuery.timeago plugin

I am using timeago jQuery plugin for my blog, but there seems to be a problem with the timing itself, and I cant put my finger and what the cause of the problem is. Its currently May 31st, 2011 02:30 local time here (GMT+DST). Now the example date I…
Ian
  • 375
  • 2
  • 6
  • 10
4
votes
1 answer

How stable is TSC (TimeStamp Counter) from user space for Intel x86-64 CPUs in 2020?

Some times I need a proper way to measure performance at nanosecond from my user space application in order to include the syscall delays in my measurement. I read many old (10yo) articles saying it isn't any stable and they are gonna remove it from…
Alexis
  • 2,136
  • 2
  • 19
  • 47
4
votes
1 answer

How parquet stores timestamp data in S3?

I have my data stored in S3 in file_name.snappy.parquet format. when I preview this file in S3 I get my timestamp field as: {"ModifiedOn": 4.535976891407963e+25} this field is created using pyspark TimestampType. when I see this field in Athena…
subham
  • 121
  • 1
  • 6
4
votes
1 answer

Convert Unix Timestamp into ms timestamp in PySpark

I have a column in my Dataframe timestamp, which contains UNIX 13-digit timestamps as follows: | timestamp | | ------------- | | 1584528257638 | | 1586618807677 | | 1585923477767 | | 1583314882085 | With pandas it is fairly easy to convert…
lenlehm
  • 67
  • 1
  • 9
4
votes
0 answers

FFmpeg - How to get the timestamp of the frame of which a thumbnail was generated?

I am using FFmpeg to extract a screenshot through the timestamp, but I get this timestamp manually by watching the video in VLC and looking for the exact moment of the thumbnail was generated, this process is very time consuming and I need to do it…
joserick
  • 327
  • 3
  • 11
4
votes
2 answers

Date in UTC in mysql

I have a table which has field with data type as DATETIME. I persist a record in this table using java and I calculate current date as as following. Date date = Calendar.getInstance(TimeZone.getTimeZone("UTC")).getTime(); But When I check my table,…
RandomQuestion
  • 6,778
  • 17
  • 61
  • 97
4
votes
2 answers

Some dates cannot be converted correctly in Java to an epoch timestamps at the midnight of a specific timezone

This Java code, given a date as a string, is supposed to print the epoch timestamp for the same date at the midnight for the CET zone (supposing I'm not in the same zone). public static void main(String[] args) throws ParseException { String…
user1883212
  • 7,539
  • 11
  • 46
  • 82
4
votes
1 answer

How to serialize a json firestore Timestamp to Date?

I store a Date in Firestore. I get an HashMap from firestore and i want to recreate my object from it. Before implementing the Date the working code was : HashMap document = new HashMap
Tom
  • 133
  • 2
  • 11
4
votes
1 answer

First Value Of Each Month In SQL

I have a database containing time stamped data values, with multiple samples per day, i.e. 05/01/11 01:00:00 - 1.23 05/01/11 01:12:34 - 0.99 .... 05/01/11 23:59:59 - 2.34 05/02/11 00:11:22 - 4.56 etc I am trying to get a list of the first…
4
votes
2 answers

iOS Core Motion how to convert timestamp to Date?

I'm examining CMRecordedAccelerometerData and it has a timestamp, defined as: The timestamp is the amount of time in seconds since the device booted. How do I convert timestamp from device last boot to NSDate? For example, the system provides a…
Alex Stone
  • 46,408
  • 55
  • 231
  • 407
4
votes
1 answer

How to remove freq='W-FRI' portion in Timestamp

okay so I have two data frames both with datetime as indices. When I call df1 index, I get: df1.index[0] Timestamp('2016-03-04 00:00:00') when I call df2 index, i get: df2.index[0] Timestamp('2016-03-11 00:00:00', freq='W-FRI') I'm trying to…
4
votes
2 answers

Convert timestamp to the formatted date time using C++

I can only use C++ standard library (C++14) to convert timestamp to the given format date-time. I new to C++ and I know that C++ doesn't support us a lot via a library like Java. At a given date and time of 2011-03-10 11:23:56 in the Central…
Nguyễn Đức Tâm
  • 1,017
  • 2
  • 10
  • 24
4
votes
1 answer

Column is of type timestamp without time zone but expression is of type character varying : Nifi

I am trying to insert CSV records to Postgres database using nifi. Sample csv file : timenow,location '2019-10-21 15:13:11','colombo' When nifi scenario runs, it gives following error Error column 'timenow' is of type timestamp without time zone…
Sachith Muhandiram
  • 2,819
  • 10
  • 45
  • 94
4
votes
3 answers

How to save Date as Timestamp in Angular Firestore?

firestore.Timestamp.now(); I tried this way and it saves date as map. nanoseconds: 388000000 seconds: 1570897877 nanoseconds and seconds type are number. I want to save date as firestore timestamp using angular. I found duplicate questions without…