Use REGEX_SUBSTR to get all characters before certain delimiter-CodePudding

Home > Back-end > Use REGEX_SUBSTR to get all characters before certain delimiter

Use REGEX_SUBSTR to get all characters before certain delimiter

Time：11-30

I am trying to parse 2021-11-16T04:42:00.000 0000 into 2021-11-16 using REGEX_SUBSTR through SQL on the Snowflake platform.

Any help would be appreciated.

CodePudding user response：

select left('2021-11-16T04:42:00.000 0000', 10);

output

2021-11-16