I am searching the equivalent of this sql query in HQL
select date_creation at time zone 'Europe/Paris',
date_cloture at time zone 'Europe/Paris'
from cot
I am getting an exception when i am trying to execute it in hibernate.
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: at near line 1,..
My goal is to load the datetime value as it saved in database.