Export to CSV removes the milliseconds

Hi,

I try to export a dataset to csv using Dremio. When a datetime has seconds and milliseconds = 0… the exported data has no seconds or milliseconds.

So the value: 2400-01-01 00:00:00.000
gets exported as: 2400-01-01T00:00

How can I solve this ‘problem’?

Krgds,

Danny

@DannyPannemans

Is the data type timestamp or string? Have you tried one with an actual value? The example you have given is all Zeros

I tried with string and it works as expected

select ‘2400-01-01 00:00:00.000’, ‘2400-01-01 19:19:19.999’

Output

{“EXPR$0”:“2400-01-01 00:00:00.000”,“EXPR$1”:“2400-01-01 19:19:19.999”}

Thanks
Bali

Hi Bali,

Thanks for your answer.
It is a timestamp.
When there are milliseconds >0 then export is fine. Do we really have to cast it to string before exporting?

Krgds,

Danny