Format date values with German date format

diff --git a/ajax/ajax.php b/ajax/ajax.php
index 5095ca6..5f2e3c9 100644 (file)
--- a/ajax/ajax.php
+++ b/ajax/ajax.php
@@ -6,7 +6,9 @@ function fetch($mask)
 {
   $fields = array("to_char(sys_edit,'DD.MM.YYYY HH24:mm') AS sys_edit", 'sys_user');
   foreach ($mask['edit'] as $field => $info)
 {
   $fields = array("to_char(sys_edit,'DD.MM.YYYY HH24:mm') AS sys_edit", 'sys_user');
   foreach ($mask['edit'] as $field => $info)

-    if ($info['type'] != 'passwd')
+    if ($info['type'] == 'date')
+      $fields[] = sprintf("to_char(%s,'DD.MM.YYYY') AS %s", $field, $field);
+    elseif ($info['type'] != 'passwd')

       $fields[] = $field;
 
   $sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
       $fields[] = $field;
 
   $sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',