Seitenhistorie

ALTER TABLE <SCHEMA>.LOGS ADD COLUMN TIME INTEGER

UPDATE <SCHEMA>.LOGS SET 
TIME =  
CAST(SUBSTRING(MESSAGE FROM POSITION('/' IN MESSAGE)+1 FOR POSITION(' ms' IN MESSAGE)-POSITION('/' IN MESSAGE)) AS INTEGER),
MESSAGE = SUBSTRING(MESSAGE FROM 0 FOR POSITION('/' IN MESSAGE))
WHERE LOGGER = 'SQLTimer'