PHP Time() in MySQL

[santlou]

First, I am a PHP Newbie....

 

I am maintaining a PHP / MySQL site.  Many of the Date fields in the database are stored as INT14 and the value is set to the PHP time() function. 

 

Using SQL Only (without PHP), is there a way that I can query the database and convert this field to a human-readable format?  I am attempting to generate some reports using a third party MySQL reporting tool... but I don't see how to convert these date fields to display the appropriate values on the reports using SQL.

 

Any Help would be very appreciated.

 

 

Thanks

[PravinS]

Use FROM_UNIXTIME() MySQL function

[kicken]

FROM_UNIXTIME

 

DATE_FORMAT