Sorry, as was mentioned earlier: select FROM_UNIXTIME(1377196112065/1000); +-----------------------------------+ | FROM_UNIXTIME(1377196112065/1000) | +-----------------------------------+ | 2013-08-22 18:28:32 | +-----------------------------------+
Have a good day everyone :) Nick.