i have a calculated field with this query:
Code: Select all
select TIMESTAMPDIFF(year,date_of_birth,NOW()) as age from employees_de where id=%ID%
"date_of_birth" as Data Type: Date
"age" as Data Type: Integer
The calculation works.
But in query logs i get that errors:
Page: /ajax-update-calculated-fields.php
UPDATE `employees_de` SET `age`='' WHERE `ID`='1'
Incorrect integer value: '' for column `app`.`employees_de`.`age` at row 1
Can someone please help me what is the problem?
Thank you very much!