
Hi, the following SQL query returns (ceate_time) e.g. "2012-05-22 11:26:39" - in the SQL query box for instance. [Kernel/System/Ticket.pm in OTRS 3.1.5] 2535 return if !$Self->{DBObject}->Prepare( 2536 SQL => 'SELECT article_sender_type_id, article_type_id, create_time FROM ' 2537 . 'article WHERE ticket_id = ? ORDER BY create_time ASC', 2538 Bind => [ \$Param{TicketID} ], 2539 ); BUT in the RowArray $Row[2] is "22.05.2012" - it's lacking the time and has german time format. 2433 while ( my @Row = $Self->{DBObject}->FetchrowArray() ) { push @SenderHistory, { SenderTypeID => $Row[0], ArticleTypeID => $Row[1], Created => $Row[2], Result is, other internal time functions get an invalid format as an input and return zero. Therefore, in case of tickets, which haven't been manually touched by agents (tickets via mailin) escalation time is wrongly calculated. This applies for OTRS 3.1.5 still. I wanted to fix it, but could do this only with a rather dirty hack because of my FetchRowarray() problems. TIA Michael