How to write timetamp with microsecond precision?


It throw exception when I try insert a value ‘2018-05-04 22:46:33.436000’ for timestamp column,
and it succeed if replace with ‘2018-05-04 22:46:33.436’.
So how to write timestamp with microsecond precision?

Thank you.

Hi @Fulton_Fu,
We don’t support microsecond date time in YCQL. Can you please open a github issue if you need this?

Note that YSQL does support it:
For example,

CREATE TABLE ts(a timestamp primary key);
INSERT INTO ts values(‘2018-05-04 22:46:33.4360105’);