We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
v0.3.32
Self Hosted (Source)
大概看了一下源码,应该是conversations表的创建语句问题,created_at、updated_at 用的是当前时区时间而 read_at 用的却是 UTC 时间,两个时间系统不一致
建议default值使用类似SET DEFAULT timezone('UTC', CURRENT_TIMESTAMP(0))的写法也使用 UTC 时间
SET DEFAULT timezone('UTC', CURRENT_TIMESTAMP(0))
另:刚发现直接修改数据库时间会导致 日志与标注 中过滤时间的下拉框不准确,怀疑此处用的时间未转为 UTC 时间
1、时间显示应该与当前时区保持一致 2、数据库中不应该出现多种不同时区的时间
时间比当前时区多了八小时
The text was updated successfully, but these errors were encountered:
Close due to #1542
Sorry, something went wrong.
takatost
No branches or pull requests
Dify version
v0.3.32
Cloud or Self Hosted
Self Hosted (Source)
Steps to reproduce
大概看了一下源码,应该是conversations表的创建语句问题,created_at、updated_at 用的是当前时区时间而 read_at 用的却是 UTC 时间,两个时间系统不一致
建议default值使用类似
SET DEFAULT timezone('UTC', CURRENT_TIMESTAMP(0))
的写法也使用 UTC 时间另:刚发现直接修改数据库时间会导致 日志与标注 中过滤时间的下拉框不准确,怀疑此处用的时间未转为 UTC 时间
✔️ Expected Behavior
1、时间显示应该与当前时区保持一致
2、数据库中不应该出现多种不同时区的时间
❌ Actual Behavior
时间比当前时区多了八小时
The text was updated successfully, but these errors were encountered: