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

Reply via email to