Select Date view data 3 days ago

The following should work for you:

Hi,

Not work ,

my seletc

/ RELATORIO FUNCIONANDO /
SELECT
SUM(VALOR) AS valor,
DATA,
ESPECIE,
CASE
WHEN (TIPO = 'SANGRIA') THEN 'SANGRIA'
WHEN (TIPO='SUPRIMENTO') THEN 'SUPRIMENTO'
WHEN (TIPO NOT like '%SANGRIA%' AND TIPO NOT LIKE '%SUPRIMENTO%') then especie
end AS NOVA
FROM MOV_OPERADORES

WHERE (VALOR > 0) AND (DATA ='CURDATE() - INTERVAL 3 DAY')

GROUP BY DATA, ESPECIE, NOVA
ORDER BY NOVA DESC
/ RELATORIO FUNCIONANDO /

THIS ERRO

Error executing query:
SQL Error State:HY000, Native Error Code: FFFFFE63, ODBC Error: [ODBC Firebird Driver][Firebird]conversion error from string "CURDATE() - INTERVAL 3 DAY"

/ RELATORIO FUNCIONANDO /
SELECT
SUM(VALOR) AS valor,
DATA,
ESPECIE,
CASE
WHEN (TIPO = 'SANGRIA') THEN 'SANGRIA'
WHEN (TIPO='SUPRIMENTO') THEN 'SUPRIMENTO'
WHEN (TIPO NOT like '%SANGRIA%' AND TIPO NOT LIKE '%SUPRIMENTO%') then especie
end AS NOVA
FROM MOV_OPERADORES

WHERE (VALOR > 0) AND (DATA ='CURDATE() - INTERVAL 3 DAY')

GROUP BY DATA, ESPECIE, NOVA
ORDER BY NOVA DESC

Thanks in advanced.

The syntax was provided for MySQL. You need to search for a similar syntax that will work with your database.

Hi,

My database is (Firebird) a try another syntax, more not work :(

you may try:
WHERE DATA > dateadd(day, -3, current_timestamp)

Hi,

Error executing query:
SQL Error State:HY000, Native Error Code: FFFFFF98, ODBC Error: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 13, column 39
day

/ RELATORIO FUNCIONANDO /
SELECT
SUM(VALOR) AS valor,
ESPECIE,
CASE
WHEN (TIPO = 'SANGRIA') THEN 'SANGRIA'
WHEN (TIPO='SUPRIMENTO') THEN 'SUPRIMENTO'
WHEN (TIPO NOT like '%SANGRIA%' AND TIPO NOT LIKE '%SUPRIMENTO%') then especie
end AS NOVA,
DATA
FROM MOV_OPERADORES
WHERE (VALOR > 0) AND DATA > dateadd(day, -3, current_timestamp)

GROUP BY ESPECIE, NOVA, data
ORDER BY NOVA DESC