hibernate/hibernate-orm · error · ParsingException

Unsupported date or time field [{ctx.getText()}]

Error message

Unsupported date or time field [{ctx.getText()}]

What it means

Error "Unsupported date or time field [{ctx.getText()}]" thrown in hibernate/hibernate-orm.

Source

Thrown at hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java:5029

			case HqlParser.YEAR ->
				//this is computed from DAY_OF_YEAR/7
					new SqmExtractUnit<>( WEEK_OF_YEAR, nodeBuilder().getIntegerType(), nodeBuilder );
			default -> throw new ParsingException( "Unsupported week field [" + ctx.getText() + "]" );
		};
	}

	@Override
	public Object visitDateOrTimeField(HqlParser.DateOrTimeFieldContext ctx) {
		final var nodeBuilder = nodeBuilder();
		final var symbol = ((TerminalNode) ctx.getChild( 0 )).getSymbol();
		return switch ( symbol.getType() ) {
			case HqlParser.DATE -> isExtractingJdbcTemporalType
					? new SqmExtractUnit<>( DATE, resolveExpressibleTypeBasic( Date.class ), nodeBuilder )
					: new SqmExtractUnit<>( DATE, resolveExpressibleTypeBasic( LocalDate.class ), nodeBuilder );
			case HqlParser.TIME -> isExtractingJdbcTemporalType
					? new SqmExtractUnit<>( TIME, resolveExpressibleTypeBasic( Time.class ), nodeBuilder )
					: new SqmExtractUnit<>( TIME, resolveExpressibleTypeBasic( LocalTime.class ), nodeBuilder );
			default -> throw new ParsingException( "Unsupported date or time field [" + ctx.getText() + "]" );
		};
	}

	@Override
	public Object visitTimeZoneField(HqlParser.TimeZoneFieldContext ctx) {
		final var nodeBuilder = nodeBuilder();
		final var symbol = ((TerminalNode) ctx.getChild( ctx.getChildCount() - 1 )).getSymbol();
		// should never happen
		return switch ( symbol.getType() ) {
			case HqlParser.TIMEZONE_HOUR, HqlParser.HOUR ->
					new SqmExtractUnit<>( TIMEZONE_HOUR, nodeBuilder().getIntegerType(), nodeBuilder );
			case HqlParser.TIMEZONE_MINUTE, HqlParser.MINUTE ->
					new SqmExtractUnit<>( TIMEZONE_MINUTE, nodeBuilder().getIntegerType(), nodeBuilder );
			case HqlParser.OFFSET ->
					new SqmExtractUnit<>( OFFSET, resolveExpressibleTypeBasic( ZoneOffset.class ), nodeBuilder );
			default -> throw new ParsingException( "Unsupported time zone field [" + ctx.getText() + "]" );
		};
	}

View on GitHub (pinned to fad1729dce)

Solutions

1. The date/time field referenced is not supported in this context. Use one of the documented date/time fields for the expression.

When it happens

Trigger: An invalid keyword/field is used in a datetime, pad, or trim expression: Unsupported date or time field [<value>]

Common situations: HQL queries using extract(), pad(), or trim() with a field/specification keyword that is not one of the documented values.

AI-assisted analysis of hibernate/hibernate-orm@fad1729dce (2026-08-22). Data as JSON: /api/errors/9a11e3a5a7bec1eb. Report an issue: GitHub.