default_as_expession is failed because of the wrong error msg

[zimulala]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_check/detail/ghpr_check/6868/pipeline/

run test [ddl/default_as_expression] err: sql:alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));: failed to run query
\"alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));\"
 around line 58,
we need(139):
alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));
Error 1292 (22007): Incorrect datetime value: '2024-03'

but got(139):
alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));
Error 1292 (22007): Incorrect datetime value: '2024-04'

[zimulala]

We need to cherry-pick this PR to v8.0 so set to severity/major