[Tutorial] Storing player chat log in MySQL, automatic deletion and periodic backups
#3

Quote:
Originally Posted by Vince
Посмотреть сообщение
Use of the datetime field is up for discussion. I've always preferred regular Unix timestamps. In any case you should use UTC_TIMESTAMP() rather than NOW(). The latter one gets the local server time, which can lead to inconsistencies if migrating the server to another country (e.g. from Europe to the US) or even if trying to display data in the user's local time.
That's, yes, true, but if the server and the SQLDB are on the same host, then it's no problem (for interaction b/w them, but still timezones would pose a problem). I've actually just added your quote, I'll look into the function and THEN include it, I don't want to blankly include it! But, thank you!
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)