ck parseDateTimeBestEffortOrZero
Cannot parse date: value is too short: Cannot parse Date from String: while executing 'FUNCTION toDate
toDate(x)
-->
x==''
toDate(parseDateTimeBestEffortOrZero (x))
2)
if(JSONExtractString(j, '$first_pay_time')='','1970-01-01 00:00:00', JSONExtractString(j, '$first_pay_time')) as user$first_pay_time
where
toStartOfDay(toDate(user$first_pay_time)) >=