[Joe70701]

Hi, I want help with my register date.
Well, The register date is inserted into the database normally, all of the date appears, like 25/05/2015.

But when I test it in a command in game, Only the year appears.

My code:

pawn Код:

COMMAND:regdate(playerid, params[])
{
        new rstring[120];
        format(rstring, sizeof(rstring), "Your register date is %d", pInfo[playerid][RegisteredOn]);
        SendClientMessage(playerid, -1, rstring);
        return 1;
}

The INSERT INTO query:

pawn Код:

mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX` ,`PosY`, `PosZ`, `Score`, `Infections`, `RegisteredOn`, `Kills`, `Deaths`) VALUES ('%e', '%s', '%s', 0, 0, 0, 0.0, 0.0, 0.0, 0, 0, NOW(), 0, 0)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
                        //Now let's create a new row and insert player's information in it
                        mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);