SQL Timestamp

[Andreas_Prouza]

Hallo Klaus,

Ich kann dir hier regex sehr ans Herz legen:

with orig as (select * from table (values ('2092013', '85203'), ('24092013', '95945'), ('24092013', '95945'), ('24092013', '95945'), ('24092013', '95945'), ('24092013', '95809'), ('7012014', '145445'), ('7012014', '145634'), ('17022014', '90631'), ('17022014', '90642')                                   ) t1 (ODREGD, ODREGT)
)
select orig.*, 
         timestamp (
               date (regexp_replace(varchar(ODREGD), '(.*)(..)(....)', '$3-$2-$1')),
               time (regexp_replace(varchar(ODREGT), '(.*)(..)(..)', '$1:$2:$3'))
            )
from orig

lg Andreas