Re: Right Date format mask

[John Meyer]

Dan Nelson wrote:
> 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".
>
>   

To quote the great sage and eminent drunkie Homer Simpson "Doh!"

Thanks.