查询MySql数据库表中的时间字段datetime，且该字段有空值时，查询会报错

[youhua38tao]

Please confirm before submission 在提交之前，请确认

• I have searched for existing issues search for existing issues, including closed ones.
  我已经搜索了现有问题搜索现有问题，包括已关闭的问题。"

Dify version Dify版本

1.9.1

db_query or db_query_pre_auth

Database Query 数据库查询

Plugin version 插件版本

0.0.11

database and version 数据库及版本

MySql 8.0

Problem description 问题描述

当查询MySql数据库表中的时间字段datetime，且该字段有空值NULL时，查询会报错 RuntimeError, error details: Error executing SQL: NaTType does not support strftime。

初步排查应该是python对NaN数据转换时间时的报错，并且本地复现成功，问题代码

dify-plugin-tools-dbquery/db_query/tools/db_util.py

Line 91 in 40a422a

elif isinstance(value, datetime.date):

[coderabbitai]

📝 CodeRabbit Plan Mode

Generate an implementation plan and prompts that you can use with your favorite coding agent.

• Create Plan

Examples

• Example 1
• Example 2

---

🔗 Similar Issues

Possible Duplicates

• mysql-datetime时间类型字段转JSON错误 #44

Related Issues

• Error executing SQL: '\u003e=' not supported between instances of 'NoneType' and 'tuple' #42
• 端口为何不可以输入呢？ #45
• 连接Oracle数据库 12.2.0.1.0报错 #38

🔗 Related PRs

#55 - fix: timestamp type conversion bug [closed]

👤 Suggested Assignees

• ShaoFeng-Guo
• Jesean
• guowseu
• 2214527294bbb-coder
• junjiem

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord or schedule a call!

[changkeke]

Please confirm before submission 在提交之前，请确认

• I have searched for existing issues search for existing issues, including closed ones.我已经搜索过现有的问题，包括已关闭的问题。
  我已经搜索了现有问题搜索现有问题，包括已关闭的问题。"

Dify version Dify版本

1.9.1

db_query or db_query_pre_auth

Database Query 数据库查询

Plugin version 插件版本

0.0.11

database and version 数据库及版本

MySql 8.0

Problem description 问题描述

当查询MySql数据库表中的时间字段datetime，且该字段有空值NULL时，查询会报错 RuntimeError, error details: Error executing SQL: NaTType does not support strftime。

初步排查应该是python对NaN数据转换时间时的报错，并且本地复现成功，问题代码

dify-plugin-tools-dbquery/db_query/tools/db_util.py

Line 91 in 40a422a

elif isinstance(value, datetime.date):

Postgresql +1