Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

01/10/24 10:12:12 (12 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -32 +32 @@
 JOIN project.diagnostics d ON t.diagnosticsID = d.ID;
 }}}
+== Прикажување на возраста на секое милениче.
+{{{
+SELECT
+  p.ID AS pet_id,
+  p.color,
+  p.description AS pet_description,
+  p.dateOfBirthday,
+  AGE(current_date, p.dateOfBirthday) AS pet_age
+FROM
+  project.pets p;
+}}}