Good day, everyone! I have a question regarding display of milliseconds in our Starrocks 3.5.2-69de616 we expect to see milliseconds in our datetime fields when copy data from postgres, becase this feature is enabled way back in v 3.3. But I see that the values are only display time up to a second. What could be a reason? Should we enable some specific variable to make it work? Recreate tables? Or reload data?

when loading

DATETIME

values, have you tried using

to_datetime

or

to_datetime_ntz

? • to_datetime (with timezone) • to_datetime_ntz (no timezone)

Nope, should I use it every time I load data from source?

In my case, when loading with Broker Load, I was able to keep millisecond precision by using

to_datetime_ntz

like this:

LOAD LABEL foo
(...)
SET (
  timestamp = to_datetime_ntz(timestamp, 3)
)