Mysql: Date as string

Question

I have a field in MySQL as varchar and need to do a select with a range. The date is in the following format "%m/%d/%Y" (Ej. 10/14/2010).

Why dont you use cast or convert varchar to date format and compare? — Sachin Shanbhag
– Sachin Shanbhag, Commented Oct 14, 2010 at 16:58
Why are you storing a date as a varchar? If it was stored as a proper date field you could use a normal 'BETWEEN' or equality testing. — Marc B
– Marc B, Commented Oct 14, 2010 at 16:58
Change this field type to DATE (and data itself accordingly). That's the only proper solution — Your Common Sense
– Your Common Sense, Commented Oct 14, 2010 at 16:59

Trevor · Accepted Answer · 2010-10-14 16:58:43Z

2

SELECT STR_TO_DATE(dateColumnName,'%m/%d/%Y');

answered Oct 14, 2010 at 16:58

Trevor

6,6995 gold badges40 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1