{
$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',