Length of Seal of Ascension and others (sql 2008 r2)

[fuz]

I realized that the buffs, bought in the in-game store (x) from my server season 6 were with the time duration wrong. I decided to check the database (SQL 2008 R2) and found that the date of duration of buffs is being reversed the month in place of the day, as shown in the following image:



The buff was purchased to last one day, should look like this:

BuyDate: 2015-01-06 ExpireDate: 2015-01-07

How did do sql 2008 not reverse the date of the month and day?
Sql 2008 r2 (Portuguese-Brazil)

Obs: is not only visual bug in the game, server stayed online two days to verify and seal of ascension or other continued active.

Sorry for my bad english!

Edit: I changed the "data type" tables "ExpireDate" and "BuyDate" from "smalldatetime" to "datetime2 (7)" and is now running smoothly. I just hope that no future problems.

[MentaL]

[KarLi]

what files do u even use etc?

[fuz]

http://forum.ragezone.com/f197/zteam...erver-1021302/