PDA

View Full Version : How do I do this correctly?


Dokins
02/04/2012, 08:01 PM
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'

My attempt:

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;
}


Now this can't be right..?