Yearning icon indicating copy to clipboard operation
Yearning copied to clipboard

[Question] 3.1.9.1 查询结果时间格式与源格式不同

Open iuwai opened this issue 1 year ago • 12 comments

描述问题 查询结果时间格式与源格式不同,容易造成误导,以为是数据库里格式不对

复现 重现该行为的步骤:

  1. 使用查询功能,查询结果中如果是date格式,结果展示格式被修改

期望的结果 保留日期源格式

截图 实际效果:

image

期望效果:
image

部署方式

  • [ ] Docker
  • [ √ ] Manual

环境 (请填写环境信息):

  • 操作系统: CentOS 7.9
  • 浏览器 所有
  • 版本号 3.1.9.1

iuwai avatar Dec 23 '24 05:12 iuwai

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Title: [Question] 3.1.9.1 The query result time format is different from the source format

Describe the problem The query result time format is different from the source format, which can easily lead to misleading people, thinking that the format in the database is incorrect.

Recurrence Steps to reproduce the behavior:

  1. When using the query function, if the query result is in date format, the result display format will be modified.

Desired results Preserve date source format

screenshot Actual effect:

image

Expected results: image

Deployment method

  • [ ] Docker
  • [√] Manual

Environment (please fill in environmental information):

  • Operating system: CentOS 7.9
  • Browser All
  • Version number 3.1.9.1

Issues-translate-bot avatar Dec 23 '24 05:12 Issues-translate-bot

Hey @iuwai! 👋 I'm here to help you with bug fixes, answer your questions, and guide you as a contributor. Let's tackle this issue together!

The issue you're experiencing with the Yearning platform, where the query result time format differs from the source format, is likely due to the way the platform formats date and time. In the Yearning codebase, date and time formatting for query results is handled using the time.Now().Format("2006-01-02 15:04") method in the ReferQueryOrder and SocketQueryResults functions within the src/handler/personal/query.go file [1]. This formatting might be causing the discrepancy you're observing.

To address this, you might need to modify the code to retain the original date format from the database. Alternatively, check if there are any configuration options available that allow you to customize the date and time format, although such options were not found in the available information.

To continue talking to Dosu, mention @dosu.


Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other

dosubot[bot] avatar Dec 23 '24 05:12 dosubot[bot]

遇到同样的问题

lanyue1122 avatar Dec 24 '24 07:12 lanyue1122

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Encountered the same problem

Issues-translate-bot avatar Dec 24 '24 07:12 Issues-translate-bot

同样问题

TemplateXu avatar Jan 09 '25 09:01 TemplateXu

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Same problem

Issues-translate-bot avatar Jan 09 '25 09:01 Issues-translate-bot

同样的问题

SoHuDrgon avatar Mar 20 '25 03:03 SoHuDrgon

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Same problem

Issues-translate-bot avatar Mar 20 '25 03:03 Issues-translate-bot

遇到同样的问题

lovebaicai avatar Jun 05 '25 05:06 lovebaicai

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


The same problem has a stable recurrence

Issues-translate-bot avatar Jun 05 '25 05:06 Issues-translate-bot

遇到同样的问题,而且导出到csv中之后,字段时间值发生了变化,非常容易误导

ddl1228 avatar Oct 14 '25 03:10 ddl1228

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


I encountered the same problem, and after exporting to csv, the field time value changed, which is very easy to mislead.

Issues-translate-bot avatar Oct 14 '25 03:10 Issues-translate-bot