Re: Localized and stripped return value of FetchrowAr ray?

Hi Michael,

Michael Scheer schreef op 2012-05-25 08:52:

> the following SQL query returns (ceate_time) e.g. "2012-05-22 
> 11:26:39"
> - in the SQL query box for instance.

...

> BUT in the RowArray $Row[2] is "22.05.2012" - it's lacking the time 
> and
> has german time format.

Could it be that you use a database such as Oracle where you can 
influence the time stamp format based on user locale?
I think that the format for Apache (which you'll see via the web front 
end) and the otrs user (which your emails will use) will return a 
different time stamp format.

In case you're using Oracle, you might want to stick this line into 
your Config.pm : $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
--
Mike
_______________________________________________
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