• Модуль: main
  • Путь к файлу: ~/bitrix/modules/main/classes/general/sql_util.php
  • Класс: CSqlUtil
  • Вызов: CSqlUtil::AddToSelect
static function AddToSelect(&$fieldKey, &$arField, &$arOrder, &$strSqlSelect)
{
	global $DB;

	if ($strSqlSelect <> '')
		$strSqlSelect .= ", ";

	// ORACLE AND MSSQL require datetime/date field in select list if it present in order list
	if ($arField["TYPE"] == "datetime")
	{
		$strSqlSelect .= $DB->DateToCharFunction($arField["FIELD"], "FULL")." as ".$fieldKey;
	}
	elseif ($arField["TYPE"] == "date")
	{
		$strSqlSelect .= $DB->DateToCharFunction($arField["FIELD"], "SHORT")." as ".$fieldKey;
	}
	else
		$strSqlSelect .= $arField["FIELD"]." as ".$fieldKey;
}