Recent Posts

Caution: Greetings to all visitors. The site is working in short. Links Please skip the link to view any topic and thank you for visiting
header ads

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.

from Databases https://ift.tt/39EzoxL
via IFTTT

Post a Comment

0 Comments