BDE Datum nach Monat sortieren

[nahpets]

Hallo,

so sollte es gehen:

SQL-Code:

SELECT date_open,
  EXTRACT(YEAR FROM date_open) AS YY,
  EXTRACT(MONTH FROM date_open) AS MM,
  EXTRACT(DAY FROM date_open) AS DD
FROM clients
order by mm, dd,yy

Extract funktioniert nicht im Order By.