| 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 mask | John Meyer | 14 Sep |
| • Re: Right Date format mask | Dan Nelson | 14 Sep |
| • Re: Right Date format mask | John Meyer | 15 Sep |
