Hello,
I want to get the initial time + the time inverted in the task as a column.
I am using dateadd. I don’t know if is the way, and i don’t understand where can be the mistake. I am following the example.
https://docs.inductiveautomation.com/display/DOC79/Data+Partitioning+and+Pruning
What is the datatype of tiempo_invertido? It needs to be numeric and not a TIME variable.
I like to use https://www.w3schools.com/sql/func_sqlserver_dateadd.asp for testing SQL scripts.
What database are you using? The error messages says:
caused by SQLSyntaxErrorException: (conn=91837) FUNCTION tallerelectrico.dateadd does not exist
The DATEADD function is available in MSSQL (as mentioned in the link you provided), but it does not exist in MySQL or Oracle databases.
Oracle
I'm not really up on Oracle, but this link shows various methods you can use to add 1 hour to column. I like this example:
select some_date_column + interval '1' hour
from your_table;
NOTE that the actual amount of time ('1') is specified as a string
MySQL
For MySQL you would use the DATE_ADD() function, EG:
SELECT DATE_ADD("2017-06-15", INTERVAL 1 HOUR);
You aren’t providing a numeric value to the query but instead the string ‘tiempo_invertido’, which your DB undoubtedly doesn’t know how to handle.
Try something like this to use a variable value:
SELECT referencia_instalacion as ItemId,
count(tarea,' ',usuario) as label,
fecha_inicio as startDate,
fecha_inicio + numtodsinterval({Path to property or tag},'hour') as EndDate
FROM tareas
More on the numtodsinterval function.
Just use the column name in the function
SELECT referencia_instalacion as ItemId,
count(tarea,' ',usuario) as label,
fecha_inicio as startDate,
fecha_inicio + numtodsinterval(tiempo_invertido,'hour') as EndDate
FROM tareas
What flavor of DB are you using?
numtodsinterval is an Oracle function.
Change numtodsinterval to interval in your query.
For MySql the query should look like this:
SELECT referencia_instalacion as ItemId,
count(tarea,' ',usuario) as label,
fecha_inicio as startDate,
fecha_inicio + INTERVAL tiempo_invertido HOUR as EndDate
FROM tareas
Your first attempt at this didn’t work because you used quotes around the column name making it a string literal which INTERVAL in MySQL can’t use.
Try as @lrose suggested:
fecha_inicio + INTERVAL tiempo_invertido HOUR as EndDate
You left the comma “,” between the column name and HOUR.
something very small makes the difference. now is working 
I am very aware that in a program that is 10’s or 100’s of Megabytes in size, your day can be ruined by a single BIT being the wrong way around 