Mysql date select from string

Question

i've issue I try this query, do not return any rows. just 0 rows. Even tho there is data matching the request..

select * from repairshop_reservations where date = DATE_FORMAT("11/06/2017 20:00:00", '%d/%m/%Y %H:%i:%s"');

Currently my content of the selected table look like this

The data value of column Date is datetime

Try: SELECT * FROM repairshop_reservations WHERE date = "11/06/2017 20:00:00"; — Soutzikevich
– Soutzikevich, Commented Jun 11, 2017 at 17:55
Default date format is as in your screenshot: where date = '2017-06-11 20:00:00' — juergen d
– juergen d, Commented Jun 11, 2017 at 17:58

ScaisEdge · Accepted Answer · 2017-06-11 18:25:38Z

1

you could use str_to_date in this way you can control the proper formatting of the date when you don't use the standard mysql format

select * from repairshop_reservations 
where date = str_to_date('11/06/2017 20:00:00', '%d/%m/%Y %H:%i:%s');

edited Jun 11, 2017 at 18:25

answered Jun 11, 2017 at 18:07

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

4 Comments

Soutzikevich Over a year ago

you have an extra "

ScaisEdge Over a year ago

@P.Soutzikevich correct answer .. updated ..thanks

Soutzikevich Over a year ago

I think what the OP wants is to have the entire row returned, but it's good to have an example of the str_to_date function in the question page for others to see. You should include in your answer when it's best to use str_to_date and when not.

ScaisEdge Over a year ago

@P.Soutzikevich .thanks for suggestion answer updated with a brief explanation

Soutzikevich · Accepted Answer · 2017-06-11 18:06:47Z

1

You are not inserting a column in your table, so you won't have to define a data type for it. That means that, you are not making changes to the conceptual scheme of your database.

Considering that your table is implemented correctly, the SQL query you would need to give you the desirable result would be:

SELECT * FROM repairshop_reservations
WHERE date = "11/06/2017 20:00:00";

You use the WHERE clause, to filter your record and get an output with a specified condition. In plain English, what you want to do is: Select and print for me, every column from the repairshop_reservations table, that has listed date as "11/06/2017 20:00:00"

answered Jun 11, 2017 at 18:06

Soutzikevich

1,0413 gold badges14 silver badges31 bronze badges

Collectives™ on Stack Overflow

Mysql date select from string

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related