Convert timestamp data in time series to datetime type

1

Hi,
I want to convert my time series database to datetime type
In the Java code, I sent timestamp data by using System.currentTimeMillis() / 1000L, in DB, it would be stored like this: 1527068797
Is it possible to convert this data into date time type, which we can understand easier
Thank you so much for your advise

2

Yes, we have several functions that can do type conversion that you can try out - https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html

3

Great, thank you so much :slight_smile:
Finally I use something like this: TO_TIMESTAMP(CAST(“C_1” AS DOUBLE))