# [Known Issues] TiDB create table 包含 datetime 字段默认值为 0 报错

## Key Words

create table, datetime, error 1067 (42000), invalid default value

## Description

create table 包含 datetime 字段默认日期为 0，遇到报错 ERROR 1067 (42000): Invalid default value.

Root CauseBUG，修复 PR [https://github.com/pingcap/tidb/issues/24165](https://github.com/pingcap/tidb/issues/24165)

## Diagnostic Steps

```sql
set @@sql_mode = (select replace(@@sql_mode,'NO_ZERO_IN_DATE',''));
set @@sql_mode = (select replace(@@sql_mode,'NO_ZERO_DATE',''));
create table t (a datetime default '2999-00-00 00:00:00');
ERROR 1067 (42000): Invalid default value for 'a'
```

## Resolution

升级到对应版本

## Workaround

修改 datetime 字段中的 "年月日" 默认值为非 0

## Affected Versions

5.1.0 - 5.1.1
5.0.0 
4.0.0 - 4.0.12