Instant - Precision


An instant can be defined at different level (known also as precision)

Precision Instant Name
year-month-day (such as an anniversary date) date
year-month-day hour
year-month-day hour:minute
year-month-day hour:minute:second datetime
year-month-day hour:minute:second.milliseconds timestamp

On a computer level, a date data type may be used to store time at the second level. (Example with java) You need to lookup the data type definition to known it's precision

Discover More
Instant - Year

A year is a unit of time that represents time at the year level. days
Data System Architecture
SQL - Timestamp Data Type

This page is the in Sql datatype. A TIMESTAMP contains the following s: YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND. If is not specified,...
Time - (Unix|POSIX|Epoch) time

Unix time (also known as POSIX time or Epoch time) is a system for describing instants in time. It's the number of milliseconds / second since a start date (generally Thursday, 1 January 1970) but if...
Time - Date

A date is a moment at the day precision level in a calendar. The date data type is a time data type. It is is an ordered numeric that should not contain any time part date data typedatetime A...
Time - DateTime

A datetime is the representation of a instant at the second precision It contains the date and time part (Hour, Minute, Seconds, ...) Timestampfractional second precision
Time - Time representation (Moment, Instant)

This section goes over the representation of time in a scalar way versus in a collection way (ie time series) Time is basically a numeric counter that increases over time. An instant in time can be represented...
Time - Timestamp

TIMESTAMP is a Sql data type that stores a instant with a precision at the fractional seconds Its an extension of the datetime datatype that adds fractional second precision. An application that must...
Time - Unit

Measurement of time is built on units, such as: years, months, days, hours, minutes, and seconds Unit of time are used to: define an instant. The more unit, the more precision define...

Share this page:
Follow us:
Task Runner