set the below configuration to retrieve the null values SET date_time_overflow_behavior= 'saturate'
reference https://clickhouse.com/docs/operations/settings/formats#date_time_overflow_behavior