milvus-io/milvus

[Feature]: Support date && datetime type

Open

#27,577 opened on Oct 9, 2023

View on GitHub
 (9 comments) (1 reaction) (1 assignee)Go (44,298 stars) (4,000 forks)batch import
good first issuehacktoberfestkind/feature

Description

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

Contributor guide

Tech stack
go
Domain
database
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
3-5 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
Go programmingDatabase type systemsMilvus architecturePostgreSQL datetime types
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
25
Research direction
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