Equivalent of substring in Impala

Question

-- else left(wof.ro_end_date, 4) + '-' + 
        substring(cast(wof.ro_end_date as varchar(20)), 5, 2) + '-' +
        right(wof.ro_end_date, 2)

This is the code that was originally used in SQL Server Management Studio. Is there any way to do this in the Impala data lake?

Hive and Impala are two different things – David דודו Markovitz Jul 28 '17 at 18:22 — David דודו Markovitz, Jul 28 '17 at 18:22
sorry mistyped in the title im working in impala – burnsa9 Jul 28 '17 at 19:08 — burnsa9, Jul 28 '17 at 19:08

score 3 · Accepted Answer · edited Jul 31 '20 at 09:58

3

Try this:

substr(cast(wof.ro_end_date as string),5,2) + '-' + strright(wof.ro_end_date, 2)

edited Jul 31 '20 at 09:58

RobertMyles

answered Aug 02 '17 at 07:38

Giri

1 Answers1