Localized and stripped return value of FetchrowAr ray?

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
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev