X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/ca5de5712845a874f8abe976d92aef945d513ca7..4159233152d5e20dfb0e7ea67c9b5b2a45e45f68:/SL/Form.pm diff --git a/SL/Form.pm b/SL/Form.pm index 9193e3356..7636b1659 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2269,10 +2269,10 @@ sub get_history { my $i = 0; if ($trans_id ne "") { my $query = - qq|SELECT h.employee_id, h.itime, h.addition, h.what_done, emp.name | . + qq|SELECT h.employee_id, h.itime::timestamp(0) AS itime, h.addition, h.what_done, emp.name | . qq|FROM history_erp h | . qq|LEFT JOIN employee emp | . - qq|ON emp.id = st.employee_id | . + qq|ON emp.id = h.employee_id | . qq|WHERE trans_id = ? | . $restriction;