Comments on: A Reference for the VI Text Editor (aka VIM) Tech Tips, Reviews, Tutorials, Occasional Rants Sat, 31 Aug 2013 15:50:35 +0000 hourly 1 By: Everett - Thu, 12 Nov 2009 22:58:34 +0000 Here’s a handy regular expression. Say you want to find and replace all instances of Oracle timestamps to MySQL timestamps?

to_timestamp(’11-NOV-09 PM’,’DD-MON-RR HH.MI.SS.FF AM’)

Should become

A simple find an replace won’t cut it because there could be ANY date and time in the target string, and normal greedy matching will replace more than you want. Instead use non-greedy matching:

By: Everett - Fri, 16 Jan 2009 19:23:01 +0000 My pleasure! Feel free to share any of your own tips or point out any errors!

By: GearNoggin Thu, 15 Jan 2009 22:07:47 +0000 Great summary. Thanks!