Rounddown DateTime to just Date in the ORDER BY Query

Hi I need help.

In the current datebase, one field (column) is datetime. It has both date and time component.
Column A. Column B is another column.

I would like to use ORDER BY date and then by column B.

So like this:

SELECT *
FROM TABLE
ORDER BY ROUNDDOWN(A) DESC, B

where rounddown rounds A to just a date not datetime.

 

Not sure what you are trying to ask, or do, but I think you can "extract" the date part. Look here
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

 

hey JEET thanks i have figured it out. I just use DATE() in the order by and it works.

Thread Closed.

 

Good to know, thanks for updating with answer