RizSilverthorn.net

Drupal stores time information (such as created date, modified date, etc) in unix date format as int(11).
Using a simple statement:

SELECT n.`created` FROM node n

FROM_UNIXTIME()

Formats the data as date & time:

SELECT FROM_UNIXTIME(n.created) FROM node n

DATE()

Just the date:

SELECT DATE(FROM_UNIXTIME(n.created))  FROM node n

Note:

Of course, you could (should?) process the date in the software you are using instead.