Lyftron supports the full set of SQL date and time data types. In most cases, a combination of DATE, DATETIME, SMALLDATETIME, TIME complete range of date/time functionality required by any application. Find all the details below.

date

Defines a date in Lyftron.

Syntax
date
Description
Property Description
Range 0001-01-01 through 9999-12-31
Accuracy 1 day
Example
SELECT CAST('2017-05-04' AS date) AS 'date';

datetime

Defines a date that is combined with a time of day with fractional seconds that is based on a 24-hour clock.

Syntax
datetime
Description
Property Description
Date range 1753-01-01 through 9999-12-31
Time range 00:00:00 through 23:59:59.997
Accuracy Rounded to increments of .000, .003, or .007 seconds
Example
SELECT CAST('2017-05-04 15:55:44.132' AS datetime) AS 'datetime';

datetime2

Defines a date that is combined with a time of day that is based on 24-hour clock. datetime2 can be considered as an extension of the existing datetime type that has a larger date range, a larger default fractional precision, and optional user-specified precision.

Syntax
datetime2 [ (fractional seconds precision) ]
Description
Property Description
Date range 0001-01-01 through 9999-12-31
Time range 00:00:00 through 23:59:59.9999999
Accuracy 100 nanoseconds
Example
SELECT CAST('2017-05-04 15:55:44.1234567 +02:30' AS datetime2(7)) AS 'datetime2';

smalldatetime

Defines a date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00) and without fractional seconds.

Syntax
smalldatetime
Description
Property Description
Date range 1900-01-01 through 2079-06-06
Time range 00:00:00 through 23:59:59
Accuracy One minute
Example
SELECT CAST('2017-05-04 15:55:44.132' AS smalldatetime) AS 'smalldatetime';

time

Defines a time of a day. The time is without time zone awareness and is based on a 24-hour clock.

Syntax
time [ (fractional second precision) ]
Description
Property Description
Range 00:00:00.0000000 through 23:59:59.9999999
Accuracy 100 nanoseconds
Example
SELECT CAST('2017-05-04 15:55:44.132' AS time(7)) AS 'time';