TO_TIMESTAMP failing when only date is provided

[laurent-cobos]

Failed SQL Query:

SELECT
	SUM("total_active_pipeline")
FROM
	"pipeline_period_coverage_metrics"
WHERE
	"from_month" >= CAST(TO_TIMESTAMP('2025-10-09', 'YYYY-MM-DD') AS TIMESTAMP)

Returned error: Error during rewrite: Can't detect Cube query and it may be not supported yet. Please check logs for additional information.

Logical Plan Cube compiled query:

SELECT
  SUM("total_active_pipeline") FROM "pipeline_period_coverage_metrics"
WHERE
  "from_month" >= CAST(str_to_date('2025-10-09', 'YYYY-MM-DD') AS TIMESTAMP)

Cube error:

TRACE [cubesql::compile::rewrite::analysis]
Can't evaluate expression: Execution("Error evaluating str_to_date('2025-10-09', '%Y-%m-%d'): input is not enough for unique date and time")

Tool GoodData Cloud

Additional context If time is included the request works:

SELECT
	SUM("total_active_pipeline")
FROM
	"pipeline_period_coverage_metrics"
WHERE
	"from_month" >= CAST(TO_TIMESTAMP('2025-10-09 10:30', 'YYYY-MM-DD HH24:MI') AS TIMESTAMP)