Hi to all,
I need help with an issue in OTRS: I'm having trouble with OTRS format date. There are certain configurations, options and the timetable in which the date format accepted by OTRS (YYYY-MM-DD) are not compatible with the Spanish date format DD-MM-YYYY. This produces errors such as:
This error occurs for example by introducing a new type or modify one of them:
No FormatTimeString () translation found for '17-DEC-07 'string!
This one, for example, occurs when trying to enter an event on the calendar:
Error: ORA-01861: literal does not match the format string (DBD ERROR: error pos [..]
Is there any way to fix this problem? I've tried from changing the configuration of the variable ENV (NLS_DATE_FORMAT) = 'YYYY-MM-DD HH24: MI: SS';, change the function FormatTimeString () and no way.
Somebody throw me some light? Thank you for all.
Errors with date format.
Moderator: crythias
-
jgbautista
- Znuny newbie
- Posts: 7
- Joined: 29 Sep 2010, 16:11
- Znuny Version: 2.2.4
-
crythias
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Errors with date format.
You should tell people what version of OTRS and what Database you're using.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
jgbautista
- Znuny newbie
- Posts: 7
- Joined: 29 Sep 2010, 16:11
- Znuny Version: 2.2.4
Re: Errors with date format.
Sorry, the database is Oracle 10g. Thanks