Wrong date in History

[ssanna]

Hello, when i open the history of a ticket i see the date completely wrong, month, day and year. This happen only in the history and also for all the new ticket just opened.
Where can i check? Thanks.
S

[jojo]

choose another language

[ssanna]

You mean for the user option? Tried without solve.

[ssanna]

Hello, can someone help me? In any ticket when i open the history the date and time are completely wrong. What can i check?
Thanks.

[jojo]

time settings of the system and the database

[ssanna]

time settings of the system and the database

Thanks for your answer but i've already check the time and all is fine and syncronized.
There's a different time for the mysqldb? Where can i found it?
Thanks.
Stefano.

[ssanna]

time settings of the system and the database

Thanks for your answer but i've already check the time and all is fine and syncronized.
There's a different time for the mysqldb? Where can i found it?
Thanks.
Stefano.

OK, from the mysql i've done the
SELECT CURTIME();
and
SELECT CURDATE();

all is correct but i see that the format is different. in the sql the value returned is YYYY/MM/DD and in the OTRS History is DD/MM/YYYY
could be this the problem? if yes, how can i modify?
By the way note that also the creation time have that format DD/MM/YYYY and that value is correct, only the history have this problem.
Thanks.
Stefano.