Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/sql-teradata-Регулярка.sql

Last active March 10, 2019 12:14
Show Gist options
  • Save ezhov-da/e4a5e2c28245dd52bff91bc0b3a719e3 to your computer and use it in GitHub Desktop.
Save ezhov-da/e4a5e2c28245dd52bff91bc0b3a719e3 to your computer and use it in GitHub Desktop.
Download ZIP
sql teradata регулярка
Raw
sql-teradata-Регулярка.sql
SELECT
CAST(
STRTOK(REGEXP_SUBSTR(Data_otpravki_nabora_KP_ot_KOP_k_NORS , '(\d+\.){2}\d+'),'.',3)||'-' ||
STRTOK(REGEXP_SUBSTR(Data_otpravki_nabora_KP_ot_KOP_k_NORS , '(\d+\.){2}\d+'),'.',2)||'-' ||
STRTOK(REGEXP_SUBSTR(Data_otpravki_nabora_KP_ot_KOP_k_NORS , '(\d+\.){2}\d+'),'.',1)
AS DATE) AS Data_otpravki_nabora_KP_ot_KOP_k_NORS
FROM TEST_EZHOV
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment