MssqlSqlHelper

MssqlSqlHelper class is used to handle MySQL database. Contains specific methods to generate SQL queries, inheriting Bitrix\Main\DB\SqlHelper. They help to generate queries without handling of specific database syntax.

Queries the following namespaces:

Method	Description	Available from version
addSecondsToDateTime	Returns SQL function to add seconds to the interval, indicated in the parameter $from.	14.0.0
castToChar	Returns CAST expression for converted field or string expression.	16.0.10
convertDateField	Converts string into object `\Bitrix\Main\Type\Date`.	15.0.1
convertDatetimeField	Converts string into object `\Bitrix\Main\Type\DateTime`.	15.0.1
convertStringField	Convert string into object `\Bitrix\Main\Type\Date`, when string has specific format.	15.0.1
formatDate	Returns a database expression for converting value `$field` according to the value `$format`.	14.0.0
forSql	Prints special symbols in the string to be used in SQL statement.
getAliasLength	Returns value of maximum length for alias in the selected statement.	14.5.3
getCharToDateFunction	Returns SQL function for converting string value into the `Date/time`.	14.0.18
getColumnTypeByField	Returns type of column according to the scalar field object.	14.5.2
getConcatFunction	Returns SQL function for concatenation of database fields and statements.
getConverter	Returns callback to be called for a field value on fetch.	15.0.1
getCurrentDateFunction	Returns SQL function for getting current date only.
getCurrentDateTimeFunction	Returns SQL function for getting current date and time.
getDatetimeToDateFunction	Returns SQL function that passes the value `$value` into the `Date/Time` database type.
getDateToCharFunction	Returns SQL function for converting database fields and statements into the string.	14.0.18
getFieldByColumnType	Returns descendant exception from `Entity\ScalarField` that matches to database type.	14.5.2
getIsNullFunction	Returns SQL function to verify database fields and expressions against NULL value.
getLeftQuote	Returns an identificator escaping left character.	14.0.0
getLengthFunction	Returns SQL function for getting field length or database expression.
getQueryDelimiter	Returns special special delimiter for batch processing.
getRightQuote	Returns an identificator escaping right character..	14.0.0
getSubstrFunction	Returns SQL function for getting portion of string.	14.0.10
getTopSql	Transforms SQL query according to `$limit` and `$offset` values.	14.0.0
prepareMerge	Builds string for SQL MERGE command for the specified table.	15.5.0
softCastTextToChar	Returns expression for string field used during grouping and sorting.	16.5.4