This message was deleted.

You can change the

format

of the

timestampSpec

of the

ingestionSpec

to be

posix

if you want the format to be seconds since the epoch https://druid.apache.org/docs/latest/ingestion/ingestion-spec/#timestampspec

@Ryan Plessner I'm aware of this thing while ingesting the data, Druid converts and saves the timestamp data in ISO 8601 format, I'm interested in Queried data in which timestamp should be in epoch seconds, Hope you got my question correctly...

ah ok I understand. I'm not aware of anything like this for native queries. It might be possible with SQL queries if you used

TIMESTAMP_TO_MILLIS