Re: REGEXP_REPLACE doesn't give the desired output

Hi Jim,

as i said I tried to hardcode the timestamp, thus the input to REGEXP_REPLACE was a character type.

Another example. Running:

SELECT REGEXP_REPLACE('1234 A B C', '\D', '') FROM dual

gives the result:

'1234 A B C' Received on Tue Jun 20 2006 - 09:04:11 CDT