我正在开发一个API来使用JPA存储库来使用下面的本地查询。在通过APi执行查询时，应用程序抛出以下错误：
错误：函数pg_catalog. timezone

@Query("""
            SELECT SUM(p.total) AS total,
                   date_trunc('day', p.date_time AT TIME ZONE 'UTC' AT TIME ZONE :zoneId) AS date
            FROM xyz p
            WHERE p.employee_id = :id
              AND p.date_time >= :startDate
              AND p.date_time <= :endDate
              AND p.date_time <= now()
              AND p.status in :statuses
            GROUP BY date
            ORDER BY date DESC
  """, nativeQuery = true)
  fun get(id: Int, zoneId: ZoneId, startDate: ZonedDateTime, endDate: ZonedDateTime, statuses: List<PaymentStatus>) : List<DTO>

我在StackOverflow中浏览了许多帖子，但无法理解这里的问题。
申请详情：Kotlin、斯普林、波斯特格雷斯
详细错误：

Caused by:
            org.postgresql.util.PSQLException: ERROR: function pg_catalog.timezone(bytea, timestamp with time zone) does not exist
              Hint: No function matches the given name and argument types. You might need to add explicit type casts.
              Position: 112