milvus-io/milvus

[Feature]: Support date && datetime type

Open

#27,577 创建于 2023年10月9日

在 GitHub 查看
 (9 评论) (1 反应) (1 负责人)Go (44,298 star) (4,000 fork)batch import
good first issuehacktoberfestkind/feature

描述

Is there an existing issue for this?

  • I have searched the existing issues

Is your feature request related to a problem? Please describe.

Timestamp is a very common datatype in all databases. We can convert timestamp into int64, but this will be a overhead for the user.

We can follow the definition of PG https://www.postgresql.org/docs/current/datatype-datetime.html about what datetime data type should behave

We need to mainly support 4 data types. Date w/without timezone time w/without timezone

And main display method and filter function on top of it

Describe the solution you'd like.

No response

Describe an alternate solution.

No response

Anything else? (Additional Context)

No response

贡献者指南

技术栈
go
领域
database
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
4
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
3-5 days
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
needs investigation
前置要求
Go programmingDatabase type systemsMilvus architecturePostgreSQL datetime types
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
25
研究方向
Examine Milvus's current type system in the `types` package and how timestamps are handled. Review PostgreSQL's datetime documentation for date/time data types and their behaviors. Look at existing issues or discussions in the repo related to datetime support. Focus on implementing four types: date, time, timestamp with time zone, timestamp without time zone, and their comparison and display functions.
[Feature]: Support date && datetime type · milvus-io/milvus#27577 | Good First Issue