Support for Unix Timestamp in DateTime for CSV and JSONEachRow Formats

Why it matters

This feature was created to allow ClickHouse to interpret DateTime fields provided as Unix timestamps when importing data via CSV and JSONEachRow formats. It solves the problem of handling Unix timestamp date/time data natively during data ingestion, making it easier and more efficient for users to work with time series or timestamped data without needing to convert timestamps externally before import.

How to use it

When importing data in CSV or JSONEachRow format that contains DateTime fields as Unix timestamps (integer seconds since epoch), ClickHouse will now correctly parse these values directly into DateTime columns. No additional configuration is required; simply provide the Unix timestamp values in the data for the corresponding DateTime columns.