.. highlightlang:: us

.. index:: Overview Date and Time, Date and Time 

.. _overview-date-and-time:

Overview Date and Time
======================

.. us.makeindex   DATETIME, Functions

.. include:: ../ftab/DATETIME.ftab

The DT_xxx function using an 8-byte floating-point number. Days are
represented by whole number increments starting with 30 December 1899,
midnight as time zero. Hour values are expressed as the absolute value of
the fractional part of the number. The following table illustrates this.

Date and time Representation:

.. list-table::
   :header-rows: 1

   * - 30 December 1899, midnight
     - 0.00
   * - 1 January 1900, midnight
     - 2.00
   * - 4 January 1900, midnight
     - 5.00
   * - 4 January 1900, 6 A.M.
     - 5.25
   * - 4 January 1900, noon
     - 5.50
   * - 4 January 1900, 9 P.M.
     - 5.875

.. us.makeindex   DT_FUNC, Functions

.. include:: ../ftab/DT_FUNC.ftab

.. seealso::
   :ref:`functions-by-categories`

:sub:`id-1904373`