[Feature]: Support datetime type

[xiaofan-luan]

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

Describe the solution you'd like.

No response

Describe an alternate solution.

No response

Anything else? (Additional Context)

No response

[fool1280]

Hi, I'm interested in tackling this issue. May I ask where should I start?

[xiaofan-luan]

Hi @fool1280

1. start from adding a type from milvus.proto https://github.com/milvus-io/milvus-proto, there is a FieldSchema fields which you can
2. implement create collection path, make sure we can create a collection with timestamp field
3. implement the insert path, this usually starts from proxy function Insert(ctx context.Context, in *InsertRequest, opts ...grpc.CallOption) (*MutationResult, error)
4. Implement the query/search path. make sure we can run where condition on datetime field

[fool1280]

Thank you. I want to ask for the DateTime, would it be possible for me to use the Timestamp type in https://protobuf.dev/reference/protobuf/google.protobuf/#timestamp, as converting into int64 would introduce overhead for the user?

[xiaofan-luan]

Thank you. I want to ask for the DateTime, would it be possible for me to use the Timestamp type in https://protobuf.dev/reference/protobuf/google.protobuf/#timestamp, as converting into int64 would introduce overhead for the user?

This is not too hard. you just need to convert date time to timestamp and there is no blocker

[dugar-tarun]

Hello @xiaofan-luan, I'm interested to take this up. Can you please assign this to me?

[xiaofan-luan]

/assign @dugar-tarun
please let me know if you need any help