Friday, July 11, 2014

regular expression for to_timestamp in sql statement

I need export the "INSERT" sql statement from one database.

Here is the sql statement

to_timestamp('07-APR-14 11.48.50.988000000 AM','DD-MON-RR HH.MI.SSXFF AM') need to be replaced by SYSDATE
Here is the regular expression I used in Notepad++.

This could be test on http://www.regexr.com/

No comments:

Post a Comment