Re: Right Date format mask

2009-09-14 Thread 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. Assu

Re: Right Date format mask

2009-09-14 Thread Dan Nelson
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 st

Right Date format mask

2009-09-14 Thread John Meyer
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs