Jump to content

How to show Human time from epoch


elentz

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/252721-how-to-show-human-time-from-epoch/
Share on other sites

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.