I have some log entries that have the date / time in epoch time. It is in a MySql db and I have a query to show everything I want. The problem is how do I change the epoch time to human time / date when the query is run? The query I am using is:
$sql = "Select stime,direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'";
The field I need to change is stime Can someone show me how to do this? It was suggested to use an alias for this but I am at a loss as to how to do it.
Thanks for any help.
$sql = "Select stime,direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'";
The field I need to change is stime Can someone show me how to do this? It was suggested to use an alias for this but I am at a loss as to how to do it.
Thanks for any help.