This occurs in my raw data: '8/31/2009 12:00:00 AM'
I want simply 2009-08-31 and ignore the time part
In my text editor I can use grep find-and-replace to 2009-8-31:
(\d\d?)/(\d\d?)/(\d\d\d\d) 12:00:00 AM,
but how do I get a leading zero to occur when needed. Maybe this calls for sed?