A timestamp is the current time of an event that is recorded by a computer. … Timestamps are also routinely used to provide information about files, including when they were created and last accessed or modified.

What is timestamp of a file in Linux?

A file in Linux has three timestamps: atime (access time) – The last time the file was accessed/opened by some command or application such as cat , vim or grep . mtime (modify time) – The last time the file’s content was modified. ctime (change time) – The last time the file’s attribute or content was changed.

What is timestamp example?

TIMESTAMP has a range of ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC. A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. … With the fractional part included, the format for these values is ‘ YYYY-MM-DD hh:mm:ss [.