Do you use MySQL? Runs perfectly on my OTRS MySQL 5 database.... But you can change the where clause to your needs and database...
Regards, Peter van Beugen -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Jozsef Valkai Verzonden: woensdag 10 januari 2007 13:55 Aan: User questions and discussions about OTRS.org Onderwerp: Re: [otrs] Reporting Work Units > SELECT > t.create_by, > u.first_name, > u.last_name, > Sum(t.time_unit) > FROM > time_accounting AS t > Left Join system_user AS u ON t.create_by = u.id > WHERE > year(t.create_time) = '2006' > GROUP BY > t.create_by Error: ERROR: function year(timestamp without time zone) does not exist -- Valkai Jozsef +36 70 36 28 147 [EMAIL PROTECTED] [EMAIL PROTECTED] lat:N 47° lon:E 19° _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/
