From: Dan Nelson
Date: September 14 2009 9:27pm
Subject: Re: Right Date format mask
List-Archive: http://lists.mysql.com/mysql/218729
Message-Id: <20090914212737.GB40881@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Sep 14), John Meyer said:
> I'm pulling in a date with the following format
> 9/14/2009 2:12:48 PM
> And using this mask to convert it using the str_to_date() function:
> %e %m %Y %r
> 
> but it keeps giving me an error.  Do I have the right mask?

Nope.  Assuming your input string is in mm/dd/yyy format, you would want a
format string of "%m/%e/%Y %r".

-- 
	Dan Nelson
	dnelson@stripped