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