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)) >=

posted @ 2024-07-03 19:03  papering  阅读(16)  评论(0编辑  收藏  举报