MySQL Lists: mysql: Right Date format mask

List:	General Discussion	« Previous Message Next Message »
From:	John Meyer	Date:	September 14 2009 8:33pm
Subject:	Right Date format mask
View as plain text

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?

Thread
• Right Date format mask	John Meyer	14 Sep
• Re: Right Date format mask	Dan Nelson	14 Sep
• Re: Right Date format mask	John Meyer	15 Sep