eXtremeSQL DateTime Data

eXtremeSQL provides the SQL data types DATE, TIME and TIMESTAMP to manage date and time values.

For an overview see page SQL Data Types

The table in page SQL Data Types shows that these three SQL types, DATE, TIME and TIMESTAMP, map to underlying 8-byte eXtremeDB datetime values.

 
    create table dt( d date, t time, ts timestamp );
     
    select FieldName, FieldTypeName from Metatable 
    where TableName = 'dt';
    FieldName       FieldTypeName   
    ----------------------------------------------------------------------
    d       DateTime 
    t       DateTime 
    ts      DateTime 
     

See page Date, Time and Datetime Fields for further information on how these fields are managed in SQL and native language APIs.