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 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.