Thread: Converting Date from String to MySQL DateTime

Hi Guys,

Just after a bit of advice. I've got a bit of data read from a CSV file uploaded by the user, and the data includes a date range. See below:

"14th - 16th October 2011."

I need to get "2010-10-14" from this as it is the start date of the event.

I was going to go through the whole rigmarole of exploding the string and comparing each piece to a date, separating the start and end dates by "-".

Anyone got any better / easier ideas?

Thanks in advance,

Martin

Hi,
Here are some tips

1)DECLARE @myDateTime DATETIME
SET @myDateTime = '2008-05-03'
Convert string
SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)
2)SELECT STR_TO_DATE('Wed Jun 17 12:06:00 2009', '%W %M %d %T %Y');