Strange mysql date problem

[bill-lancaster]

ORDER BY date seems not to be working.

Code: Select all

  hResult = hConn.Find("transactions", "ORDER BY TransDate")

produces:-

• 27/01/0022 00:00:00
  27/01/0022 00:00:00
  31/01/0022 00:00:00
  31/01/0022 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00

The first four records are out of sequence, the remainder are all correct.

The first four records are the most recent addition to the database so perhaps something has changed in Gambas3 or in mysql
Gambas v3.18.2
mysql Ver 8.0.33-0ubuntu0.22.04.2

This is a worrying failure of a basic function so any ideas would be appreciated.

[gbWilly]

produces:-

• 27/01/0022 00:00:00
  27/01/0022 00:00:00
  31/01/0022 00:00:00
  31/01/0022 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00
  01/12/2021 00:00:00

The first four records are out of sequence, the remainder are all correct.

I see a correct order as the year 22 is way before 2021.
I guess you wanted the year 2022 instead of 22, but put in the wrong year.

[bill-lancaster]

Thank you gbWilly, panic over. I think a visit to the opticians might be in order!