How can I use the function 'interval' in a formula?
Code:
<property name="breackageDate"
type="date"
formula="(select s.realized_date + t.age * (interval '1 day')
from gpm_concrete.concrete_series s
join gpm_concrete.test_tubes t
on t.concrete_serie_id = s.id and t.id = id)"/>
Code:
ERROR: no existe el esquema «testtube0_»
2009-11-17 11:44:10 CET SENTENCIA: select testtube0_.id as id49_, testtube0_.concrete_serie_id as concrete2_49_, testtube0_.age as age49_, testtube0_.weight as weight49_, testtube0_.breackage_load as breackage5_49_, (select s.realized_date + t.age * (testtube0_.interval '1 day') from gpm_concrete.concrete_series s join gpm_concrete.test_tubes t on t.concrete_serie_id = s.id and t.id = testtube0_.id) as formula0_ from gpm_concrete.test_tubes testtube0_, gpm_concrete.concrete_series concretese1_ where testtube0_.concrete_serie_id=concretese1_.id and concretese1_.job_id=29430
(Sorry for my bad english)