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 dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org