02.04.2012, 20:01
Quote:
Note that in MySQL, you can use the FROM_UNIXTIME() function to retrieve a date: Code: mysql> SELECT FROM_UNIXTIME(1196440219); -> '2007-11-30 10:30:19' mysql> SELECT FROM_UNIXTIME(1196440219) + 0; -> 20071130103019.000000 mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(), -> '%Y %D %M %h:%i:%s %x'); -> '2007 30th November 10:30:59 2007' |
pawn Код:
stock GetDate(timestamp)
{
new query[300];
format(query, sizeof(query), "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(%d),'%D %M %Y %h:%i')", timestamp);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() > 0)
{
format(query, sizeof(query), "%s", timestamp);
}
mysql_free_result();
return 1;
}