4 Feb
2005
4 Feb
'05
4:11 p.m.
In the installation I'm involved in we also use minutes (integer) as time units. At the end of the month a aggregate my units per ticket into a list and add this as appendix to my invoice, 'cause I get paid for handling tickets in this case. So I'm also 'raw' on the database: select tn, customer_id, sum (time_unit) from time_accounting ta , ticket t where ta.ticket_id = t.id and ta.create_by = 5 and (ta.create_time >= '2005-01-01 00:00:00') and (ta.create_time < '2005-02-01 00:00:00') group by tn, customer_id order by tn; 5 is just my user id Hth Gerold