Regular Expression for notepad++ to find to_timestamp in oracle dump

Data dump from oracle contained to_timestamp entries which do not work when used in MS SQL Server.

The regular expression to find these entries in notepad++, to change them for MS SQL:
(non-greedy search of .*? did not work but this does)

to_timestamp\(([^(\))]*)\)

References:

Advertisements