How to show Human time from epoch

[elentz]

I need some help here.  I have a query:

 

$sql =  "Select stime,direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'"

 

I use it with BaaGrid.  It shows everything I need, with one exception.  stime is in Epoch time .  So how do I change the query to show Human time instead of Epoch?

 

Thanks alot for any help

[Pikachu2000]

You'll be wanting the MySQL date & time functions FROM_UNIXTIME() and DATE_FORMAT(). Then just alias the field, and you're good to go.

[elentz]

Here's what I have tried:

$start=date(r,stime);

 

$sql =  "Select stime as $start,direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'";

 

But I get this:Warning: date() expects parameter 2 to be long, string given in /home/communiq/public_html/smdr/smdrbytrunk.php on line 81

 

The alias is the $start isn't it?

 

 

Thanks

[fenway]

I have no idea what you're trying to do -- but the alias should be a literal, not vice versa.

[elentz]

Thanks for the help.  I did get it to work as I wanted

[fenway]

Thanks for the help.  I did get it to work as I wanted

Great -- please post your solution.

[elentz]

Here's what I eventually ended up with.

 

$sql =  "Select FROM_UNIXTIME(stime,'%h:%i:%s  %c-%e-%Y'),direction,Trunk,Source,destination,CallLength,status from export where Trunk = 'nexVortex'";

 

I am sure it isn't pretty from some standpoint, but it works as I need it with one exception, the stime is in GMT and I need to get it to show Eastern.

 

Thanks

[fenway]

CONVERT_TZ() will help you.

[elentz]

Thanks Fenway I will check it out