MYSQL Order by Clause is not working on Currencies table when column name is Date and column Data Type is Date and time

Question

I have database table for currencies. I update currencies on daily basis by using google finance API along with date and time. My column name is Date and data type is datetime

I want to fetch currency rate of Dollar which is last updated on database on basis of date, instead of id of table.

Below queries shows always same result.

SELECT * FROM `currencyrates` WHERE CurrencyCode='USD' AND Rate > 0  ORDER BY 'Date' ASC

SELECT * FROM `currencyrates` WHERE CurrencyCode='USD' AND Rate > 0  ORDER BY 'Date' DESC

It always shows records from 2015, instead it should show record of 2019 first because records exits in database i checked it by sorting in my SQL tool (SQLyog).

And note that 'Date' is a string constant. Perhaps you were thinking of \`Date\` — Strawberry, May 31 '19 at 06:31

score 0 · Answer 1 · answered May 31 '19 at 06:23

0

*SELECT * FROM currencyrates WHERE CurrencyCode='USD' AND Rate >= 0 ORDER BY 'Date' ASC

SELECT * FROM currencyrates WHERE CurrencyCode='USD' AND Rate >= 0 ORDER BY 'Date' DESC*

answered May 31 '19 at 06:23

pearl

26
2

1

'Date' is a string constant. – Strawberry May 31 '19 at 06:24
Above queries always shows same result i check your query in which you mention order by desc – Rahat Hameed May 31 '19 at 06:28
You can try this https://stackoverflow.com/questions/9511882/sorting-by-date-time-in-descending-order – pearl May 31 '19 at 06:37
Adding string constant solved my problem ORDER BY `Date` it is not same as ORDER BY 'Date'. I was using column as string. – Rahat Hameed May 31 '19 at 17:23
https://stackoverflow.com/questions/9511882/sorting-by-date-time-in-descending-order?noredirect=1&lq=1 – pearl Jun 01 '19 at 10:45

MYSQL Order by Clause is not working on Currencies table when column name is Date and column Data Type is Date and time

1 Answers1