Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

Interval Conversions

Type Name

SQL Type

Parameters

INTERVAL DAY

SQL_INTERVAL_DAY

Whole Day Precision

For example: INTERVAL DAY (3)

INTERVAL DAY TO HOUR

SQL_INTERVAL_DAY_TO_HOUR

Day Precision

For example: INTERVAL DAY (2)

INTERVAL DAY TO MINUTE

SQL_INTERVAL_DAY_TO_MINUTE

Day Precision

For example: INTERVAL DAY (2) TO MINUTE

INTERVAL DAY TO SECOND

SQL_INTERVAL_DAY_TO_SECOND

Day Precision, Fractional Seconds Precision

For example: INTERVAL DAY (2) TO SECOND (3)

INTERVAL HOUR

SQL_INTERVAL_HOUR

Hour Precision

For example: INTERVAL HOUR (3)

INTERVAL HOUR TO MINUTE

SQL_INTERVAL_HOUR_TO_MINUTE

Hour Precision

For example: INTERVAL HOUR (2)

INTERVAL DAY TO SECOND

SQL_INTERVAL_HOUR_TO_SECOND

Hour Precision, Fractional Seconds Precision

For example: INTERVAL HOUR (3) TO SECOND (4)

INTERVAL MINUTE

SQL_INTERVAL_MINUTE

Minute Precision

For example: INTERVAL MINUTE(2)

INTERVAL MINUTE SECOND

SQL_INTERVAL_MINUTE_TO_SECOND

Minute Precision, Fractional Seconds Precision

For example: INTERVAL MINUTE (3) SECOND (4)

INTERVAL MONTH

SQL_INTERVAL_MONTH

Month Precision

For example: INTERVAL MINUTE(2)

INTERVAL SECOND

SQL_INTERVAL_SECOND

Whole Seconds Precision, Fractional Seconds Precision

For example: INTERVAL SECOND (4,5)

INTERVAL YEAR

SQL_INTERVAL_YEAR

Year Precision

For example: INTERVAL YEAR(3)

INTERVAL YEAR TO MONTH

SQL_INTERVAL_YEAR_TO_MONTH

Year Precision

For example: INTERVAL YEAR(2) TO MONTH)