Problem with FROM_UNIX. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problem with FROM_UNIX. (/showthread.php?tid=559344)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problem with FROM_UNIX. (/showthread.php?tid=559344)
Problem with FROM_UNIX. - Baltimore - 22.01.2015
Hello !
I have a query:
pawn Код:
mysql_format(MySQLConnect, query, 512, "SELECT FROM_UNIXTIME(`Timestamp`, '%%d-%%m-%%Y а %%H:%%I:%%S') AS Timestamp, Admin, Raison FROM `warns` WHERE SQLid = %d", PlayerInfo[playerid][ID]);
mysql_tquery(MySQLConnect, query, "Show", "ii", playerid, playerid);
With the website http://www.timestamp.fr/: 1421947410 = 22/1/2015 а 18:23:30.
But, with my query, the result = 22-01-2015 а 18:06:30...
Why?
++