List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 14 2009 9:27pm
Subject:Re: Right Date format mask
View as plain text  
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
Thread
Right Date format maskJohn Meyer14 Sep
  • Re: Right Date format maskDan Nelson14 Sep
    • Re: Right Date format maskJohn Meyer15 Sep