MYSQL - BETWEEN 2 DATES - Date Field is a String cannot convert to Date Field because of Format 2/27/2012
I have a table in which one of the rows is Dates. Unfortunately the database I uploaded it from used the 2/27/2011 format. Since the format is wrong for mysql ( 2011-2-27 ) I cannot change the type of field too Date. I need a way to convert the string date field to an actual date field so I can use the between command. SELECT * FROM Properties WHERE STR_TO_DATE(`Sold Date`, '%a, %c %b %Y %k:%i:%s') between '2011-06-15' AND '2011-06-21' I've been doing a little reading i'm lost. Ultimately I'm trying to pull anything from Present to the last 6 months date on mysql.
In this project you compete with other providers. The best outcome is chosen by the buyer and its provider is rewarded. For more information see the FAQ.
Use the "Project Type" filter on the left to filter all contest projects.In this project you place a bid to offer the price you wish to receive for performing it. The buyer chooses the provider by price and impression. For more information see the FAQ.
Use the "Project Type" filter on the left to filter all bidding projects.