Return query sorted by date, does not work

Asked

Viewed 51 times

1

SELECT * FROM eventos ORDER BY Datainicio DESC

I’m sending this to my mysql database is the first time I try to organize data by date, someone can tell me why my events don’t get sorted ?

php mysql

  • In what format you have Datainicio?

  • The format is date Y.m.d

  • what type is set for the "Start Date" column? and again the question, it was not clear about the format. It is like Y.m.d or Y-m-d ?

  • Like I wanted to ask

  • I told you the format type is Y.m.d

  • No, that’s the format, like it’s Text, Varchar...

  • I also said date

  • and what is happening? how is it coming?

Show 3 more comments

1 answer

0


Error solved after studying , I found that phpmyadmin orders differently from the actual organization of the data , now when accessing through my app I am developing saw that the data were already organized by date.

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.