santlou Posted July 13, 2013 Share Posted July 13, 2013 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 Link to comment https://forums.phpfreaks.com/topic/280118-php-time-in-mysql/ Share on other sites More sharing options...
PravinS Posted July 13, 2013 Share Posted July 13, 2013 Use FROM_UNIXTIME() MySQL function Link to comment https://forums.phpfreaks.com/topic/280118-php-time-in-mysql/#findComment-1440576 Share on other sites More sharing options...
kicken Posted July 13, 2013 Share Posted July 13, 2013 FROM_UNIXTIME DATE_FORMAT Link to comment https://forums.phpfreaks.com/topic/280118-php-time-in-mysql/#findComment-1440577 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.