hibernate/hibernate-orm · error · ParsingException

Unsupported datetime field [{ctx.getText()}]

Error message

Unsupported datetime field [{ctx.getText()}]

What it means

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

Source

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

					nodeBuilder().getLongType(),
					nodeBuilder
			);
			case HqlParser.WEEK -> new SqmExtractUnit<>(
					TemporalUnit.WEEK,
					nodeBuilder().getIntegerType(),
					nodeBuilder
			);
			case HqlParser.QUARTER -> new SqmExtractUnit<>(
					TemporalUnit.QUARTER,
					nodeBuilder().getIntegerType(),
					nodeBuilder
			);
			case HqlParser.EPOCH -> new SqmExtractUnit<>(
					TemporalUnit.EPOCH,
					nodeBuilder().getLongType(),
					nodeBuilder
			);
			default -> throw new ParsingException( "Unsupported datetime field [" + ctx.getText() + "]" );
		};
	}

	@Override
	public Object visitDayField(HqlParser.DayFieldContext ctx) {
		final var nodeBuilder = nodeBuilder();
		final var symbol = ((TerminalNode) ctx.getChild( 2 )).getSymbol();
		return switch ( symbol.getType() ) {
			case HqlParser.MONTH ->
					new SqmExtractUnit<>( DAY_OF_MONTH, nodeBuilder().getIntegerType(), nodeBuilder );
			case HqlParser.WEEK ->
					new SqmExtractUnit<>( DAY_OF_WEEK, nodeBuilder().getIntegerType(), nodeBuilder );
			case HqlParser.YEAR ->
					new SqmExtractUnit<>( DAY_OF_YEAR, nodeBuilder().getIntegerType(), nodeBuilder );
			default -> throw new ParsingException( "Unsupported day field [" + ctx.getText() + "]" );
		};
	}

View on GitHub (pinned to fad1729dce)

Solutions

1. The datetime field used in the extraction is not supported. Use a supported field (year, month, day, hour, minute, second, epoch, ...) for the extract()/datetime field expression.

When it happens

Trigger: An invalid keyword/field is used in a datetime, pad, or trim expression: Unsupported datetime 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/2ca7a0151ca1757d. Report an issue: GitHub.