Time - Unit

Data System Architecture


Measurement of time is built on units, such as:

Unit of time are used to:

  • define an instant. The more unit, the more precision
  • define an amount of time (ie duration or period) when every unit has a quantity (2 year, …)

Second is the base unit of time in the International System of Units (SI), see Time - Second

The units of time are also known as the datetime fields because they make up a date time value.

Documentation / Reference

Recommended Pages
Data System Architecture
Date - time part

The time part of an instant are the following components : Hour, Minute, Seconds from . Example: 02:00:00 hours 3600000 milli-seconds (a negative number is milliseconds before January...
Data System Architecture
Instant - Year

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

A SQL DATE is a sql datatype that represents a date and contains therefore the s YEAR, MONTH, and DAY; See date...
Data System Architecture
SQL - Interval

time duration is known as interval in SQL. An SQL interval data type descriptor contains: the name of the interval data type (INTERVAL); an indication of whether the interval data type is : a...
Data System Architecture
SQL - TIME data type

The time data type is a SQL data type that represents the time part of a instant. ie TIME contains the s HOUR, MINUTE, and SECOND. The ANSI syntax is: If
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,...
Data System Architecture
Time - (Duration|Elapsed Time)

A duration is the period of time between two event occurrences, computed as the difference of the time coordinates of those events. A duration is a amount of time that may be expressed in term of unit...
Data System Architecture
Time - Comparison

Items of type time are mutually comparable only if they have the same datetime fields See also
Data System Architecture
Time - Day

A day is a unit of time. If you add the unit year and month, you get a date. Over time the average length of the day is getting longer as the Earth slows. As a result, the length of a solar day in 2012...

Share this page:
Follow us:
Task Runner