Date and time functions

Devart ODBC Driver for xBase supports the following date and time SQL functions.

Function	Description
`CTOD(X)`	Converts string expression `X` to a date.
`DAY(X)`	Returns the day of the month as a numeric value from date or datetime expression `X`.
`DTOC(X[, N])`	Converts date expression `X` to a string. Optional `N` specifies the resulting format: `0` – (Default) `YYYY-MM-DD` `1` – `YYYYMMDD`
`DTOS(X)`	Converts date expression `X` to a string in the `YYYYMMDD` format.
`MONTH(X)`	Returns the month as a numeric value (`1` to `12`) from date or datetime expression `X`.
`TTOC(X[, N])`	Converts datetime expression `X` to a string. Optional `N` specifies the resulting format: `1` – (Default) `YYYYMMDDhhmmss` `2` – `hh:mm:ss` `3` – `YYYY-MM-DDThh:mm:ss`
`TTOD(X)`	Converts datetime expression `X` to a date by removing the time portion.
`YEAR(X)`	Returns the year as a numeric value from date or datetime expression `X`.

Note

Devart ODBC Driver for xBase is powered by the SQLite engine, therefore the driver also supports the full set of date and time SQL functions supported by Devart ODBC Driver for SQLite.