[Konstantinos]

DATE_FORMAT can be used in queries to select the date and time with a format you apply. For example:

PHP код:

"SELECT DATE_FORMAT(register_date,'%W, %e %M %Y %r') AS date_time FROM players WHERE Name='Maro06';" 


That would return (let's say register_date has the timestamp of few seconds ago): Monday, 25 May 2015 06:57:35 PM

Keep in mind that you'll have to use % sign twice in format or mysql_format functions (PAWN).