Parsing error? 'syntax error, unexpected 'FORMAT' (T_STRING'

Asked Jan 25 '21 at 16:41

Active Jan 25 '21 at 16:41

Viewed 22 times

I'm trying to get the number returned by the SQL statement to be formatted, so basically to contain commas once the number is in the thousands.

$countsQuery = (new yii\db\Query())
            ->SELECT FORMAT(COUNT(['CS']), N'#.00')
            // ->select(['COUNT(*) AS count, `CS`'])
            ->from(TaggedData::tableName())
            ->leftJoin(SurveyInstance::tableName(), 'survey_instance_id = survey_instance.id');

What am I doing wrong? the SQL statement works without me trying to format it. the error I am getting is

'syntax error, unexpected 'FORMAT' (T_STRING'

asked Jan 25 '21 at 16:41

Sharoze Khan

1

there is a space between SELECT and FORMAT – SubCore Jan 25 '21 at 16:43
`N'#.00'` doesn't look like a valid expression either – zeterain Jan 25 '21 at 16:44
@SubCore @zeterain I changed the statement to `->select(FORMAT(COUNT(['CS']),1))` which gets rid of the error but brings up **Call to undefined function common\models\FORMAT()** now – Sharoze Khan Jan 25 '21 at 16:48

Parsing error? 'syntax error, unexpected 'FORMAT' (T_STRING'

0 Answers0