How to Convert MySQL Date within MySQL Query?

Question

I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd?

Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?

Thanks

duplicate? check stackoverflow.com/questions/2030407/…

juanmirocks
– juanmirocks

2011-03-21 15:15:38 +00:00
Commented Mar 21, 2011 at 15:15 — juanmirocks
– juanmirocks, Commented Mar 21, 2011 at 15:15

Nicola Cossu · Accepted Answer · 2011-03-21 15:37:51Z

1

Take a look at str_to_date() function

select str_to_date('01/01/2011','%d/%m/%Y')

So, your search becomes

select * from table where date_field = str_to_date(your_variable,'%d/%m/%Y')

edited Mar 21, 2011 at 15:37

answered Mar 21, 2011 at 15:08

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

How to Convert MySQL Date within MySQL Query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related