Tabela Dinamica com Calculo

Ola Pessoal

Me da Uma Luz Ai... To tentando de varias maneiras mais esta dando um erro aqui e não estou sabendo fazer funcionar o script a baixo

Erro: Conexão Efetuada com sucesso!Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval))::DATE AS data, 'descricao' as descricao, CASE WHEN random() < ' at line 2 )

Minha Base esta assim ( lc_movimento )
Id | descricao | data | valor

<?php
//include"config.php";

$pdo = new PDO("mysql:host=localhost;dbname=mrangelc_teste", "mrangelc_01", "" );


//$pdo = new PDO('pgsql:<conn-string>');


$result = $pdo->query("select
(('month',CURRENT_DATE) + CAST(FLOOR(s.idx / 5) || ' day' as interval))::DATE AS data,
'descricao' as descricao,
CASE WHEN random() < 0.5 THEN ROUND(150 + (random()*100)::numeric,2) ELSE ROUND(150 + (random()*100)::numeric,2) * -1 END as valor
from lc_movimento(1,24) as s(idx)");

$ultimaData = null;
$acumulado = 0;
$totalEntradaDia = 0;
$totalSaidaDia = 0;

echo '<table>';

while($row = $result->fetch(PDO::FETCH_ASSOC)) {
$date = DateTime::createFromFormat('Y-m-d', $row['data']);
$key = $date->format('Ymd');

if($ultimaData !== null && $ultimaData != $key) {
printf('<tr><td colspan="2">Entrada: %s, Saida: %s, Saldo dia: %s, Saldo acumulado: %s</td></tr>',
number_format($totalEntradaDia,2,',','.'),
number_format($totalSaidaDia,2,',','.'),
number_format($totalEntradaDia + $totalSaidaDia,2,',','.'),
number_format($acumulado,2,',','.')
);

$totalSaidaDia = 0;
$totalEntradaDia = 0;
}

$ultimaData = $key;

printf('<tr><td>%s</td><td>%s</td><td>R$ %s</td></tr>',
$date->format('d'),
$row['descricao'],
number_format($row['valor'],2,',','.')
);

if($row['valor'] > 0) {
$totalEntradaDia += $row['valor'];
} else {
$totalSaidaDia += $row['valor'];
}

$acumulado += $row['valor'];
}

echo '</table>';

printf('<tr><td colspan="2">Entrada: %s, Saida: %s, Saldo dia: %s, Saldo acumulado: %s</td></tr>',
number_format($totalEntradaDia,2,',','.'),
number_format($totalSaidaDia,2,',','.'),
number_format($totalEntradaDia + $totalSaidaDia,2,',','.'),
number_format($acumulado,2,',','.')
);