Gabor Zele created IMPALA-12691: ----------------------------------- Summary: conversion of partial date strings to timestamp Key: IMPALA-12691 URL: https://issues.apache.org/jira/browse/IMPALA-12691 Project: IMPALA Issue Type: Improvement Reporter: Gabor Zele
Currently the TO_TIMESTAMP(STRING date, STRING pattern) function will only convert a string to timestamp if it has year, month and day parts. If I'd like to convert a single year or year/month combination: {noformat} SELECT TO_TIMESTAMP('2024-01','yyyy-MM'), TO_TIMESTAMP('2024','yyyy') ;{noformat} I always get NULL as result. To be able to convert these values, especially if there string contains something else as well, requires regexp_extract() and some other functions to match the partial format and expand it with "01" as default values for day/month so CAST/to_timestamp() will work eventually. If Impala could do the same based on a partial string pattern, then these kind of conversions would be much simpler and maintainable. -- This message was sent by Atlassian Jira (v8.20.10#820010)