Store date and time in tarantool

Question

Suppose I need a field in tuple which should be date with time. Tarantool doesn't support date and time types out of the box.

I see two solutions:

Store date and time as string and parse it.
Store date and time in epoch seconds and convert it when needed.

What is the best solution to work with dates and times in Tarantool?

score 2 · Accepted Answer · answered Nov 19 '16 at 18:46

2

You should use UNIX time format (seconds since the beginning of the UNIX epoch) for two reasons: - it's compact - the desired ordering can be achieved with TREE index on 'unsigned' type. If you deal with multiple time zones, it's best to convert to UNIX time before inserting into the database, and store the time zone in a separate field.

answered Nov 19 '16 at 18:46

Kostja

1,607
10
17

It sure does add some credibility when you click on someones profile and it says "CTO at " :D – DarkWiiPlayer Jul 23 '19 at 11:34

score 1 · Answer 2 · answered Feb 23 '22 at 16:07

1

Support of datetime is an upcoming feature in Tarantool 2.10.0.

answered Feb 23 '22 at 16:07

Sergey Bronnikov

31
1
4

Store date and time in tarantool

2 Answers2