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
10 answers

PHP Convert timestamp to months and days

How can I convert a timestamp difference between 2 dates $diff = abs(strtotime($date2) - strtotime($date1)); to months and days quantity as desired ouput: $res = 4.05 //-> 4 months and 5 days
Blackbeard
  • 652
  • 2
  • 8
  • 22
4
votes
2 answers

angularjs timestamp to datetime format string in input field

I am saving datetime in timestamp string using the following: date_default_timezone_set('Europe/London'); $bdatetime = "31-03-2016 21:52"; $date = new DateTime($bdatetime); $bdatetimeTS = $date->getTimestamp(); which is…
Developer
  • 25,073
  • 20
  • 81
  • 128
4
votes
1 answer

Calculating daily average from irregular time series using pandas

I am trying to obtain daily averages from an irregular time series from a csv-file. The data in the csv-file start at 13:00 on 20 September 2013 and run till 10:57 on 14 January 2014: Time Values 20/09/2013 13:00 …
user2143353
  • 87
  • 1
  • 6
4
votes
1 answer

Generate series of dates - using date type as input

Documentation for generate_series says that argument can be int or bigint for generate_series(start, stop) and generate_series(start, stop, step) cases and timestamp or timestamp with time zone for generate_series(start, stop, step interval). What…
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
4
votes
4 answers

batch - File last modification time with seconds

I want to know when a file has been modified for the last time. I can get these infos using the following batch script: FOR %%i IN (myfile) DO SET modif_time=%%~ti The problem is that I need the second of the last modification and the command %~t…
user3133076
  • 75
  • 1
  • 2
  • 11
4
votes
3 answers

How to convert PostgreSQL timestamp with time zone to DateTime?

This is a date which I get in my application: String psqlDate = "2013-11-17 14:08:33+01"; What is best way to convert psqlDate to joda DateTime? [EDIT] I can use DateTime parse method. It works fine with timestamp whitch have splitted information…
Lukas Hajdu
  • 806
  • 7
  • 18
4
votes
2 answers

Converting Timestamp observable to YEAR-MONTH-DAY format for polymer Dart

What the title states. I am calling a cloud endpoint that records the submission time of a record as a Java Date. When I call for the record form this endpoint it returns it to Dart as a timestamp which I have binded through polymer to a…
user1318747
  • 345
  • 4
  • 12
4
votes
3 answers

Is there a simple way to get scaled unix timestamp in C++

I'm porting some PHP to C++. Some of our database code stores time values as unix time stamps *100 The php contains code that looks a bit like this. //PHP static function getTickTime() { return round(microtime(true)*100); } I need something…
Michael Anderson
  • 70,661
  • 7
  • 134
  • 187
4
votes
2 answers

Time difference in oracle

Hi i have the following table which contains Start time,end time, total time STARTTIME | ENDTIME | TOTAL TIME TAKEN | 02-12-2013 01:24:00 | 02-12-2013 04:17:00 | 02:53:00 | I need to update the TOTAL TIME TAKEN…
Sathish
  • 4,403
  • 7
  • 31
  • 53
4
votes
1 answer

In WebAPI 2 using Json.Net a SQL Server Timestamp serializes but does not deserialize

A SQL Server Timestamp becomes a byte[] in a POCO object. The object gets serialized and the timestamp becomes a base 64 string. An example is 'AAAAAAA2QDE=' When the object is posted back to the server, during Model Validation you get: The value…
Glenn D Orr
  • 156
  • 2
  • 5
4
votes
2 answers

Distributed Systems: Keeping timestamp consistency between different nodes

Context We have a distrubuted system. We emit events from one of those systems which are read from another system for report generation. Logical order is ensured by the fact that even if the emitter system has N nodes there is a finite state machine…
4
votes
2 answers

How to check if the timestamp is current date's timestamp

I have a scheduler that needs to check if the incoming timestamp is current day's timestamp. The incoming timestamp will be of the format Eg:1384956395. How to check this in java? Please help. I am not using Joda
Poppy
  • 2,902
  • 14
  • 51
  • 75
4
votes
5 answers

64-bit php timestamp issue

Need to be able to use dates beyond the 32-bit timestamp limit so upgraded our server to Windows Server 2003 64-bit version. And running php 5.2.5 64-bit. However still can't use dates beyond the 32-bit limit. echo strtotime("11-11-2050"); returns…
Jason
  • 1,496
  • 4
  • 29
  • 41
4
votes
0 answers

What will happen with unix timestamp after 2038

Okay so I've figured out why timestamps can't go over 2038 because of the 32 bit integers, that's cool. But I couldn't help but wonder what will be done to overcome this problem. I can't seem to find a straight answer to that question anywhere and…
php_nub_qq
  • 15,199
  • 21
  • 74
  • 144
4
votes
1 answer

AppleScript: QuickTime movie recording automatic save after it's finished recording

I am trying to write a small AppleScript for a project where I have to: Start a QuickTime movie recording minimize the window of the recording open a movie that will put itself in full screen once the movie is finished playing, the recording should…
pdeli
  • 436
  • 3
  • 13
1 2 3
99
100