From 7e57b1fe0c1e3d865402b521bf8844b9cae88757 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 21 Feb 2007 09:27:03 +0000 Subject: [PATCH] =?utf8?q?Historie:=20Den=20Einf=C3=BCgezeitpunkt=20nur=20?= =?utf8?q?sekundengenau=20darstellen.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/Form.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/Form.pm b/SL/Form.pm index 5a692be21..7636b1659 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2269,7 +2269,7 @@ 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 = h.employee_id | . -- 2.20.1