25 May
2012
25 May
'12
9:31 a.m.
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