10.12.2016, 10:48
Set the column as timestamp. Then in VALUES part, you call NOW() function or even better set a default value to CURRENT_TIMESTAMP. If you ever want to retrieve when the player registered, execute a query:
the registration date is in row index 0 and field index 0 or just set an alias and retrieve it by its column name. You can change the specifiers in DATE_FORMAT if you want to, more here: https://dev.mysql.com/doc/refman/5.5...on_date-format
pawn Код:
SELECT DATE_FORMAT(RegDate, '%%d/%%m/%%Y %%r') FROM accounts WHERE ...