One way would be using the FROM_UNIXTIME() function.
Register Hereor login if you are already a member
Do you need to change the actual DB table or just be able to access the date portion of the field.
There are many links on the web that reference doing one or the other. Here is a sample http://webrewrite.com/convert-timestamp-date-time-format-mysql/