 (defn recent-transactions
   [limit]
   (jdbc/query db-spec
-              ["SELECT t.id, t.amount, t.date, t.description, c.name
+              ["SELECT t.id,
+               round(t.amount::numeric, 2) AS amount,
+               t.date, t.description, c.name
                FROM transactions t
                INNER JOIN categories c
                ON c.id = t.category_id

  [category-id]
  (jdbc/query db-spec
              ["SELECT EXTRACT(month FROM transactions.date) AS month,
               SUM(transactions.amount) AS amount
               FROM transactions WHERE category_id = ?
               GROUP by month ORDER
               BY month DESC" category-id]))

  [category-id]
  (jdbc/query db-spec
              ["SELECT EXTRACT(DOY from transactions.date) doy,
               round(SUM(transactions.amount)::numeric, 2) AS amount
               FROM transactions WHERE category_id = ?
               AND EXTRACT(ISOYEAR FROM transactions.date) =
                EXTRACT(ISOYEAR FROM current_date)
