HQL equivalent of Postgres' “datetime at time

2019-08-25 06:22发布

问题:

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.