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
1 answer

Get all rows from the last N days with HBase

I'm trying to write a component that fetches rows from HBase from the last 5 days (5 is arbitrary). The timestamp I want to use is the default timestamp HBase gives to rows (unless its problematic for some reason) I know I can use scan and with…
Gideon
  • 2,211
  • 5
  • 29
  • 47
4
votes
3 answers

Implement CreatedAt and UpdatedAt timestamp for DynamoDB Android SDK

Need help with DynamoDB. I am switching back end from Parse.com (because they are retiring parse) to AWS mobile hub. I want to capture and save the date and time for which a row or item of data is written into my dynamodb table. In parse it is done…
4
votes
0 answers

kibana/elasticsearch filter for "all records with the maximum value in field"

I'm looking for a filter for an kibana visualization that will select only records having the maximum value in a specific field.* In my case it's a timestamp field, so that only the most recent records are returned. It's a manually set field and all…
Scott
  • 1,247
  • 3
  • 10
  • 21
4
votes
2 answers

Convert unix epoch time to a date in Apache Derby

Is there a function in Apache Derby than can convert a unix epoch time value (eg. 1453974057 ) into a date?
Fidel
  • 7,027
  • 11
  • 57
  • 81
4
votes
0 answers

Laravel timestamps fields vs mysql current_timestamp

A theoretical issue. Laravel eloquent migration $table->timestamps(); made up two fields. created_at and updated_at. Both timestamp type. Default value 0000-0.... MySQL tables can be created as follows. created_at datetime NOT NULL DEFAULT…
Andris Briedis
  • 434
  • 1
  • 3
  • 13
4
votes
2 answers

Assembler instruction: rdtsc

Could someone help me understand the assembler given in https://gcc.gnu.org/onlinedocs/gcc/Extended-Asm.html It goes like this: uint64_t msr; asm volatile ( "rdtsc\n\t" // Returns the time in EDX:EAX. "shl $32, %%rdx\n\t" // Shift…
Leta
  • 331
  • 1
  • 4
  • 16
4
votes
1 answer

Find if any files recently changed, as fast as possible

I have a fairly large directory structure with thousands of files. I want to figure out if any have changed since a particular time. Now, I can use find -mmin 30 -type f ..to find any files that changed in the last 30 minutes. However, this…
Stan
  • 1,227
  • 12
  • 26
4
votes
4 answers

How to get Last 3 hours data from SQLite

I am inserting data in table with current system time like System.currentTimeMillis(). So, while getting data I need to take last 3 hours data only. Following link not help me. because this link using specific date format which I don't…
Sandip Armal Patil
  • 6,241
  • 21
  • 93
  • 160
4
votes
3 answers

Reformatting date in MYSQL for output in PHP

I have a ROW in my database's table that is a TYPE = timestamp. So the saved date format is like this: 2015-11-30 14:54:04 I googled it and said this is default timestamp format of MYSQL. How can I echo this date in PHP using this…
Paolo Medina
  • 303
  • 4
  • 15
4
votes
1 answer

Google Sheets Automatic Timestamp Script for Multiple Tabs

I am making a large google spreadsheet with multiple sheet tabs. When I edit Column 6, I need a timestamp to automatically be entered into Column 1. I need this to happen independently in every sheet. Here is the script that I have so far, and it…
4
votes
2 answers

filemtime returns same value before and after modification of file

Im trying to get the last modified time of a file before and after i write to it using fwrite. But, i get the same values for some reason. "; $e=fopen('log.txt', 'w'); fwrite($e,…
Haider Ali
  • 918
  • 2
  • 9
  • 26
4
votes
1 answer

InfluxDB data input file timestamp format

Trying to load some sample data into InfluxDB and had a question about the timestamp format. I have two files in the first the timestamp (epoch) is in second precision e.g. 1439856000 and loading the file via curl the timestamp is interpreted…
Mark Morris
  • 81
  • 1
  • 1
  • 2
4
votes
2 answers

Sort timestamp in python dictionary

mydict = [{'Counted number': '26', 'Timestamp': '8/10/2015 13:07:38'},{'Counted number': '14','Timestamp': '8/10/2015 11:51:14'},{'Counted number': '28','Timestamp': '8/10/2015 13:06:27'}, {'Counted number': '20','Timestamp': '8/10/2015…
Tom
  • 71
  • 1
  • 1
  • 4
4
votes
3 answers

what method can I use to get the timezone abbreviation in all browsers?

In Chrome, Safari, and Firefox I'm using a call like this: var date = new Date(); date.toTimeString().match(/\((.*)\)/) But this doesn't work in IE 9 because IE 9 returns it's data without the parenthesis. And this doesn't work in IE 11 because IE…
Jason M
  • 1,013
  • 13
  • 25
4
votes
1 answer

Yii2 model->created_date is in the future and not returned on queries

I have set the Yii->application->configuration->timezone to UTC and have model attributeBehaviors to insert/update the timestamp using PHP's time() method automatically. The issue, is that the timestamp that is saved to the db is in the future and…
Mike Pearson
  • 505
  • 1
  • 6
  • 18