Converting timestamp to time ago in PHP e g 1 day ago 2 days ago

Question

I am trying to convert a timestamp of the format 2009-09-12 20 57 19 and turn it into something like 3 minutes ago with PHP   I found a useful script to do this  but I think it s looking for a different format to be used as the time variable  The script I m wanting to modify to work with this format is   function  ago  tm  rcs   0         cur tm   time          dif    cur tm- tm       pds   array  second   minute   hour   day   week   month   year   decade         lngh   array 1 60 3600 86400 604800 2630880 31570560 315705600        for  v   sizeof  lngh -1    v  gt   0  amp  amp    no    dif  lngh  v   lt  1    v--   if  v  lt  0   v   0    tm    cur tm-  dif  lngh  v             no   floor  no           if  no  lt  gt  1               pds  v     s            x   sprintf   d  s    no  pds  v            if   rcs    1  amp  amp   v  gt   1  amp  amp    cur tm-  tm   gt  0                x    time ago   tm           return  x          I think on those first few lines the script is trying to do something that looks like this  different date format math     dif   1252809479 - 2009-09-12 20 57 19    How would I go about converting my timestamp into that  unix   format

User · Answer

I usually use this to find out difference between current and passed datetime stamp

OUTPUT

//If difference is greater than 7 days
7 June 2019

// if difference is greater than 24 hours and less than 7 days
1 days ago
6 days ago

1 hour ago
23 hours ago

1 minute ago
58 minutes ago

1 second ago
20 seconds ago

CODE

//return current date time
function getCurrentDateTime(){
    //date_default_timezone_set("Asia/Calcutta");
    return date("Y-m-d H:i:s");
}
function getDateString($date){
    $dateArray = date_parse_from_format('Y/m/d', $date);
    $monthName = DateTime::createFromFormat('!m', $dateArray['month'])->format('F');
    return $dateArray['day'] . " " . $monthName  . " " . $dateArray['year'];
}

function getDateTimeDifferenceString($datetime){
    $currentDateTime = new DateTime(getCurrentDateTime());
    $passedDateTime = new DateTime($datetime);
    $interval = $currentDateTime->diff($passedDateTime);
    //$elapsed = $interval->format('%y years %m months %a days %h hours %i minutes %s seconds');
    $day = $interval->format('%a');
    $hour = $interval->format('%h');
    $min = $interval->format('%i');
    $seconds = $interval->format('%s');

    if($day > 7)
        return getDateString($datetime);
    else if($day >= 1 && $day <= 7 ){
        if($day == 1) return $day . " day ago";
        return $day . " days ago";
    }else if($hour >= 1 && $hour <= 24){
        if($hour == 1) return $hour . " hour ago";
        return $hour . " hours ago";
    }else if($min >= 1 && $min <= 60){
        if($min == 1) return $min . " minute ago";
        return $min . " minutes ago";
    }else if($seconds >= 1 && $seconds <= 60){
        if($seconds == 1) return $seconds . " second ago";
        return $seconds . " seconds ago";
    }
}

User · Answer

The following is a very simple and extremely efficient solution   function timeElapsed  originalTime             timeElapsed time  - originalTime                        You can change the values of the following 2 variables            based on your opinion  For 100  accuracy  you can call           php s cal days in month   and do some additional coding           using the values you get for each month  After all the           coding  your final answer will be approximately equal to           mine  That is why it is okay to simply use the average           values below                      averageNumbDaysPerMonth  365 242 12            averageNumbWeeksPerMonth   averageNumbDaysPerMonth 7             time1      timeElapsed 60  60  24  365 242            time2 floor  time1    Years          time3   time1- time2   365 242            time4   time3  averageNumbDaysPerMonth            time5 floor  time4    Months          time6   time4- time5   averageNumbWeeksPerMonth           time7 floor  time6    Weeks          time8   time6- time7  7           time9 floor  time8    Days          time10   time8- time9  24           time11 floor  time10    Hours          time12   time10- time11  60           time13 floor  time12    Minutes          time14   time12- time13  60           time15 round  time14    Seconds           timeElapsed  time2    yrs      time5    months      time7                          weeks      time9     days      time11    hrs                           time13    mins and      time15    secs             return  timeElapsed       echo timeElapsed 1201570814     Sample output   6yrs 4months 3weeks 4days 12hrs 40mins and 36secs

User · Answer

This function prints the difference between two php datetime objects   in a more human readable form   inputs should be like strtotime  date  function humanizeDateDiffference  now  otherDate null  offset null       if  otherDate    null            offset    now -  otherDate            if  offset    null            deltaS    offset 60           offset    60           deltaM    offset 60           offset    60           deltaH    offset 24           offset    24           deltaD     offset  gt  1  ceil  offset   offset              else          throw new Exception  Must supply otherdate or offset  from now               if  deltaD  gt  1           if  deltaD  gt  365                years   ceil  deltaD 365               if  years   1                   return  last year                  else                  return   lt br gt  years years ago                                      if  deltaD  gt  6               return date  d-M  strtotime   deltaD days ago                              return   deltaD days ago             if  deltaD    1           return  Yesterday             if  deltaH    1           return  last hour             if  deltaM    1           return  last minute             if  deltaH  gt  0           return  deltaH   hours ago             if  deltaM  gt  0           return  deltaM   minutes ago             else          return  few seconds ago

User · Answer

Here s my solution for a notification module I built some time ago  It returns output similar to Facebook s notifications dropdown  eg  1 day ago  Just now  etc    public function getTimeDifference  time          Let s set the current time      currentTime   date  Y-m-d H i s         toTime   strtotime  currentTime          And the time the notification was set      fromTime   strtotime  time          Now calc the difference between the two      timeDiff   floor abs  toTime -  fromTime    60          Now we need find out whether or not the time difference needs to be in       minutes  hours  or days     if   timeDiff  lt  2             timeDiff    Just now         elseif   timeDiff  gt  2  amp  amp   timeDiff  lt  60             timeDiff   floor abs  timeDiff       minutes ago         elseif   timeDiff  gt  60  amp  amp   timeDiff  lt  120             timeDiff   floor abs  timeDiff   60       hour ago         elseif   timeDiff  lt  1440             timeDiff   floor abs  timeDiff   60       hours ago         elseif   timeDiff  gt  1440  amp  amp   timeDiff  lt  2880             timeDiff   floor abs  timeDiff   1440       day ago         elseif   timeDiff  gt  2880             timeDiff   floor abs  timeDiff   1440       days ago              return  timeDiff

User · Answer

This is actually a better solution I ve found  Uses jQuery however it works perfectly  Also it refreshes automatically similar to the way SO and Facebook does so you don t have to refresh the page to see the updates     This plugin will read your datetime attr in the  lt time gt  tag and fill it in for you     e g   4 minutes ago  or  about 1 day ago   http   timeago yarp com

User · Answer

Try this  I found it from my old codes  which shows the correct Result  function ago  datefrom   dateto   -1           Defaults and assume if 0 is passed in that        its an error rather than the epoch      if   datefrom    0            return  A long time ago             if   dateto    -1             dateto   time                  Make the entered date into Unix timestamp from MySQL datetime field       datefrom   strtotime  datefrom           Calculate the difference in seconds betweeen        the two timestamps       difference    dateto -  datefrom          Based on the interval  determine the        number of units between the two dates        From this point on  you would be hard        pushed telling the difference between        this function and DateDiff  If the  datediff        returned is 1  be sure to return the singular        of the unit  e g   day  rather  days       switch  true               If difference is less than 60 seconds             seconds is a good interval of choice         case strtotime  -1 min    dateto   lt   datefrom                datediff    difference               res     datediff    1     datediff     second     datediff     seconds               break             If difference is between 60 seconds and            60 minutes  minutes is a good interval         case strtotime  -1 hour    dateto   lt   datefrom                datediff   floor  difference   60                res     datediff    1     datediff     minute     datediff     minutes               break             If difference is between 1 hour and 24 hours            hours is a good interval         case strtotime  -1 day    dateto   lt   datefrom                datediff   floor  difference   60   60                res     datediff    1     datediff     hour     datediff     hours               break             If difference is between 1 day and 7 days            days is a good interval                         case strtotime  -1 week    dateto   lt   datefrom                day difference   1              while  strtotime  -     day difference     day    dateto   gt    datefrom                     day difference                                datediff    day difference               res     datediff    1     yesterday     datediff     days               break             If difference is between 1 week and 30 days            weeks is a good interval                     case strtotime  -1 month    dateto   lt   datefrom                week difference   1              while  strtotime  -     week difference     week    dateto   gt    datefrom                     week difference                                datediff    week difference               res     datediff    1     last week     datediff     weeks               break             If difference is between 30 days and 365 days            months is a good interval  again  the same thing            applies  if the 29th February happens to exist            between your 2 dates  the function will return            the  incorrect  value for a day         case strtotime  -1 year    dateto   lt   datefrom                months difference   1              while  strtotime  -     months difference     month    dateto   gt    datefrom                     months difference                                datediff    months difference               res     datediff    1     datediff     month     datediff     months                break             If difference is greater than or equal to 365            days  return year  This will be incorrect if            for example  you call the function on the 28th April            2008 passing in 29th April 2007  It will return            1 year ago when in actual fact  yawn   not quite            a year has gone by         case strtotime  -1 year    dateto   gt    datefrom                year difference   1              while  strtotime  -     year difference     year    dateto   gt    datefrom                     year difference                                datediff    year difference               res     datediff    1     datediff     year     datediff     years               break            return  res      Example  echo ago  2020-06-03 00 14 21 AM     Output  6 days

User · Answer

I modified the original function a bit to be  in my opinion more useful  or logical       display  X time  ago   rcs is precision depth function time ago   tm   rcs   0       cur tm   time        dif    cur tm -  tm     pds   array  second   minute   hour   day   week   month   year   decade       lngh   array 1 60 3600 86400 604800 2630880 31570560 315705600      for   v   count  lngh  - 1    v  gt   0   amp  amp     no    dif    lngh  v    lt   1    v--       if   v  lt  0         v   0      tm    cur tm -   dif    lngh  v        no     rcs   floor  no    round  no       if last denomination  round    if   no    1       pds  v      s      x    no          pds  v      if    rcs  gt  0   amp  amp    v  gt   1        x           this- gt time ago   tm   rcs - 1      return  x

User · Answer

There is some issue with some language display time ago for example in Arabic there 3 needed formats to display date  I use this functions in my projects hopefully they can help someone  any suggestion or improvement I ll be apperciate                   param   string  date1      param   string  date2 the date that you want to compare with  date1     param   int  level       param   bool  absolute        function app date diff   date1   date2   level   3   absolute   false           date1   date create  date1           date2   date create  date2        diff   date diff   date1   date2   absolute          d              invert    gt   diff- gt invert                diffs              y    gt   diff- gt y            m    gt   diff- gt m            d    gt   diff- gt d              level reached   0       foreach  diffs as  k  gt  v             if  level reached  gt    level                break                     if  v  gt  0                 d  k     v               level reached                          return   d                   function date timestring   periods   format    latin    separator                 formats              latin    gt                 y    gt    year   years                 m    gt    month   months                 d    gt    day   days                       arabic    gt                 y    gt                                        m    gt                                       d    gt                                                formats    formats  format         string            foreach  periods as  period  gt  value             if  isset  formats  period                  continue                      string  period     value              if  format     arabic                 if  value    2                     string  period     formats  period  1                elseif  value  gt  2  amp  amp   value  lt   10                     string  period      formats  period  2                else                   string  period      formats  period  0                           elseif  format     latin                  string  period       value  gt  1     formats  period  1     formats  period  0                         return implode  separator   string        function timeago   date           today   date  Y-m-d h i s          diff   app date diff  date  today 2        if  diff  invert      1            return                unset  diff 0          date timestring   date timestring  diff  latin         return  About    date timestring       date1   date  Y-m-d     date2    2018-05-14     diff   timeago  date2   echo  diff

User · Answer

it help you check it     function calculate time span  seconds        year   floor  seconds  31556926    months   floor  seconds  2629743    week floor  seconds  604800    day   floor  seconds  86400     hours   floor  seconds   3600     mins   floor   seconds -   hours 3600     60     secs   floor  seconds   60    if  seconds  lt  60   time    secs   seconds ago    else if  seconds  lt  3600    time    mins  1   mins  now   mins   mins ago    else if  seconds  lt  86400   time     hours  1   hours   hour ago   hours   hours ago    else if  seconds  lt  604800   time     day  1   day   day ago   day   days ago    else if  seconds  lt  2629743   time     week  1   week   week ago   week   weeks ago    else if  seconds  lt  31556926   time    months  1    months   month ago   months   months ago    else  time     year  1    year   year ago   year   years ago   return  time          seconds   time   - strtotime  post- gt post date    echo calculate time span  seconds

User · Answer

This function is not made to be used for the English language  I translated the words in English  This needs more fixing before using for English   function ago  d     ts   time   - strtotime str replace  -       d             if  ts gt 315360000   val   round  ts 31536000 0    year           else if  ts gt 94608000   val   round  ts 31536000 0    years           else if  ts gt 63072000   val     two years           else if  ts gt 31536000   val     a year            else if  ts gt 24192000   val   round  ts 2419200 0    month           else if  ts gt 7257600   val   round  ts 2419200 0    months           else if  ts gt 4838400   val     two months           else if  ts gt 2419200   val     a month             else if  ts gt 6048000   val   round  ts 604800 0    week           else if  ts gt 1814400   val   round  ts 604800 0    weeks           else if  ts gt 1209600   val     two weeks           else if  ts gt 604800   val     a week            else if  ts gt 864000   val   round  ts 86400 0    day           else if  ts gt 259200   val   round  ts 86400 0    days           else if  ts gt 172800   val     two days           else if  ts gt 86400   val     a day            else if  ts gt 36000   val   round  ts 3600 0    year           else if  ts gt 10800   val   round  ts 3600 0    years           else if  ts gt 7200   val     two years           else if  ts gt 3600   val     a year            else if  ts gt 600   val   round  ts 60 0    minute           else if  ts gt 180   val   round  ts 60 0    minutes           else if  ts gt 120   val     two minutes           else if  ts gt 60   val     a minute            else if  ts gt 10   val   round  ts 0    second           else if  ts gt 2   val   round  ts 0    seconds           else if  ts gt 1   val     two seconds           else  val    ts   a second             return  val

User · Answer

I am using following function for several years  And it is working fine   function timeDifference  timestamp         otherDate  timestamp       now  date  Y-m-d H i s          secondDifference  strtotime  now - strtotime  otherDate        extra         if   secondDifference    2592000            months       difference    secondDifference 2592000        difference   round  difference 0        if   difference gt 1     extra  s           difference    difference   month   extra   ago     else if  secondDifference  gt  2592000        difference timestamp  timestamp     elseif   secondDifference  gt   604800            weeks       difference    secondDifference 604800        difference   round  difference 0        if   difference gt 1     extra  s           difference    difference   week   extra   ago       elseif   secondDifference  gt   86400            days       difference    secondDifference 86400        difference   round  difference 0        if   difference gt 1     extra  s           difference    difference   day   extra   ago       elseif   secondDifference  gt   3600            hours        difference    secondDifference 3600        difference   round  difference 0        if   difference gt 1     extra  s           difference    difference   hour   extra   ago       elseif   secondDifference  lt  3600            hours         for seconds  less than minute      if  secondDifference lt  60                       if  secondDifference  0                         secondDifference 1                    if   secondDifference gt 1     extra  s              difference    secondDifference   second   extra   ago               else         difference    secondDifference 60           if   difference gt 1     extra  s    else  extra               difference   round  difference 0             difference    difference   minute   extra   ago               FinalDifference    difference   return  FinalDifference

User · Answer

Use example    echo time elapsed string  2013-05-01 00 22 35    echo time elapsed string   1367367755      timestamp input echo time elapsed string  2013-05-01 00 22 35   true     Input can be any supported date and time format   Output    4 months ago 4 months ago 4 months  2 weeks  3 days  1 hour  49 minutes  15 seconds ago   Function    function time elapsed string  datetime   full   false         now   new DateTime       ago   new DateTime  datetime        diff    now- gt diff  ago         diff- gt w   floor  diff- gt d   7        diff- gt d -   diff- gt w   7        string   array           y    gt   year            m    gt   month            w    gt   week            d    gt   day            h    gt   hour            i    gt   minute            s    gt   second              foreach   string as  k   gt   amp  v            if   diff- gt  k                 v    diff- gt  k          v     diff- gt  k  gt  1    s                   else               unset  string  k                         if    full   string   array slice  string  0  1       return  string   implode        string      ago     just now

User · Answer

time elapsed   timeAgo  time ago     The argument  time ago is in timestamp  Y-m-d H i s format     Function definition  function timeAgo  time ago         time ago   strtotime  time ago        cur time     time         time elapsed      cur time -  time ago       seconds       time elapsed        minutes      round  time elapsed   60         hours        round  time elapsed   3600        days         round  time elapsed   86400         weeks        round  time elapsed   604800        months       round  time elapsed   2600640         years        round  time elapsed   31207680           Seconds     if  seconds  lt   60           return  just now               Minutes     else if  minutes  lt  60           if  minutes  1               return  one minute ago                     else              return   minutes minutes ago                         Hours     else if  hours  lt  24           if  hours  1               return  an hour ago            else              return   hours hrs ago                         Days     else if  days  lt   7           if  days  1               return  yesterday            else              return   days days ago                         Weeks     else if  weeks  lt   4 3           if  weeks  1               return  a week ago            else              return   weeks weeks ago                         Months     else if  months  lt  12           if  months  1               return  a month ago            else              return   months months ago                         Years     else          if  years  1               return  one year ago            else              return   years years ago

User · Answer

I don t know why nobody mention Carbon yet   https   github com briannesbitt Carbon  This is actually an extension to php dateTime  which was already used here  and it has  diffForHumans method  So all you need to do is    dt   Carbon  parse  2012-9-5 23 26 11 123789    echo  dt- gt diffForHumans      more examples  http   carbon nesbot com docs  api-humandiff  Pros of this solution    it works for future dates and will return something like in 2 months etc  you can use localization to get other languages and the pluralization works fine if you will start using Carbon for other things working with dates will be as easy as never

User · Answer

This is what I went with  Its a modified version of Abbbas khan s post    lt  php    function calculate time span  post time           seconds   time   - strtotime  post      year   floor  seconds  31556926      months   floor  seconds  2629743      week floor  seconds  604800      day   floor  seconds  86400       hours   floor  seconds   3600      mins   floor   seconds -   hours 3600     60       secs   floor  seconds   60     if  seconds  lt  60   time    secs   seconds ago     else if  seconds  lt  3600    time    mins  1   mins  now   mins   mins ago     else if  seconds  lt  86400   time     hours  1   hours   hour ago   hours   hours ago     else if  seconds  lt  604800   time     day  1   day   day ago   day   days ago     else if  seconds  lt  2629743   time     week  1   week   week ago   week   weeks ago     else if  seconds  lt  31556926   time    months  1    months   month ago   months   months ago     else  time     year  1    year   year ago   year   years ago     return  time                uses      post time  2017-12-05 02 05 12       echo calculate time span  post time

User · Answer

just pass the date time to this func  it would print out in time ago format for you  date default timezone set  your-time-zone    function convert  datetime      time strtotime  datetime      diff time  - time     diff  60     var1 floor  diff      var  var1 lt  1    min     mins     if  diff gt  60        diff  60       var1 floor  diff        var  var1 lt  1    hr     hrs       if  diff gt  24   diff  24  var1 floor  diff   var  var1 lt  1    day     days       if  diff gt  30 4375   diff  30 4375  var1 floor  diff   var  var1 lt  1    month     months       if  diff gt  12   diff  12  var1 floor  diff   var  var1 lt  1    year     years           echo  var1      var   ago

User · Answer

Many solutions here did not account for rounding  For example   Event happened at 3pm two days ago  If you are checking at 2pm  it will show one day ago  If you are checking at 4pm it will show two days ago   If you are working with unix time  this helps      how long since event has passed in seconds  secs   time   -  time ago      how many seconds in a day  sec per day   60 60 24      days elapsed  days elapsed   floor  secs    sec per day       how many seconds passed today  today seconds   date  G   3600   date  i     60   date  s        how many seconds passed in the final day calculation  remain seconds    secs    sec per day   if  today seconds  lt   remain seconds         days elapsed       echo  The event was    days ago   days ago      It is not perfect if you are worried about leap seconds and daylight savings time

User · Answer

Here is my solution please check and modify according your requirements  function getHowLongAgo  date   display   array  Year    Month    Day    Hour    Minute    Second     ago                 date default timezone set  Australia Sydney             timestamp   strtotime  date            timestamp    int   timestamp           current time   time             diff    current time -  timestamp             intervals in seconds          intervals   array               year    gt  31556926   month    gt  2629744   week    gt  604800   day    gt  86400   hour    gt  3600   minute    gt  60                       now we just find the difference         if   diff    0                return   Just now                       if   diff  lt  60                return  diff    1    diff     second ago      diff     seconds ago                       if   diff  gt   60  amp  amp   diff  lt   intervals  hour                   diff   floor  diff    intervals  minute                 return  diff    1    diff     minute ago      diff     minutes ago                       if   diff  gt    intervals  hour    amp  amp   diff  lt   intervals  day                   diff   floor  diff    intervals  hour                 return  diff    1    diff     hour ago      diff     hours ago                       if   diff  gt    intervals  day    amp  amp   diff  lt   intervals  week                   diff   floor  diff    intervals  day                 return  diff    1    diff     day ago      diff     days ago                       if   diff  gt    intervals  week    amp  amp   diff  lt   intervals  month                   diff   floor  diff    intervals  week                 return  diff    1    diff     week ago      diff     weeks ago                       if   diff  gt    intervals  month    amp  amp   diff  lt   intervals  year                   diff   floor  diff    intervals  month                 return  diff    1    diff     month ago      diff     months ago                       if   diff  gt    intervals  year                   diff   floor  diff    intervals  year                 return  diff    1    diff     year ago      diff     years ago                      Thanks

User · Answer

I tried this and works fine for me   datetime1   new DateTime  2009-10-11     datetime2   new DateTime  2009-10-10     difference    datetime1- gt diff  datetime2   echo formatOutput  difference    function formatOutput  diff          function to return the highrst defference fount        if  is object  diff            return             if  diff- gt y  gt  0           return  diff- gt y     year    diff- gt y  gt  1  s        ago               if  diff- gt m  gt  0           return  diff- gt m     month    diff- gt m  gt  1  s        ago               if  diff- gt d  gt  0           return  diff- gt d     day    diff- gt d  gt  1  s        ago               if  diff- gt h  gt  0           return  diff- gt h     hour    diff- gt h  gt  1  s        ago               if  diff- gt i  gt  0           return  diff- gt i     minute    diff- gt i  gt  1  s        ago               if  diff- gt s  gt  0           return  diff- gt s     second    diff- gt s  gt  1  s        ago              Check this link for reference here  Thanks  and have fun

User · Answer

I m aware that there are several answers here  but this is what I came up with  This only handles MySQL DATETIME values as per the original question I was responding to  The array  a needs some work  I welcome comments on how to improve  Call as   echo time elapsed string  2014-11-14 09 42 28     function time elapsed string  ptime           Past time as MySQL DATETIME value      ptime   strtotime  ptime           Current time as MySQL DATETIME value      csqltime   date  Y-m-d H i s            Current time as Unix timestamp      ctime   strtotime  csqltime            Elapsed time      etime    ctime -  ptime          If no elapsed time  return 0     if   etime  lt  1           return  0 seconds               a   array  365   24   60   60    gt    year                    30   24   60   60    gt    month                         24   60   60    gt    day                              60   60    gt    hour                                   60    gt    minute                                    1    gt    second               a plural   array   year      gt   years                           month     gt   months                           day       gt   days                           hour      gt   hours                           minute    gt   minutes                           second    gt   seconds              foreach   a as  secs   gt   str              Divide elapsed time by seconds          d    etime    secs          if   d  gt   1                  Round to the next lowest integer               r   floor  d                  Calculate time to remove from elapsed time              rtime    r    secs                 Recalculate and store elapsed time for next loop             if   etime -  rtime    lt  0                    etime -    r - 1     secs                            else                   etime -   rtime                               Create string to return              estring    estring    r           r  gt  1    a plural  str     str                             return  estring     ago

User · Answer

Slightly modified answer from above      commentTime   strtotime  whatever     today         strtotime  today       yesterday     strtotime  yesterday       todaysHours   strtotime  now   - strtotime  today     private function timeElapsedString       commentTime       todaysHours       today       yesterday          tokens   array          31536000   gt   year           2592000   gt   month           604800   gt   week           86400   gt   day           3600   gt   hour           60   gt   minute           1   gt   second              time   time   -  commentTime       time     time  lt  1    1    time      if   commentTime  gt    today     commentTime  lt   yesterday            foreach   tokens as  unit   gt   text                if   time  lt   unit                    continue                            if   text     day                      numberOfUnits   floor   time -  todaysHours     unit    1                else                    numberOfUnits   floor   time    unit                             return  numberOfUnits          text      numberOfUnits  gt  1     s            ago                   else           return  Yesterday

User · Answer

If you are using PostgreSQL then it will do the job for you  const DT SQL    lt  lt  lt SQL WITH lapse AS  SELECT     timestamp 0  - now    timestamp 0    text t  SELECT CASE   WHEN  select t from lapse       s -  THEN replace  select t from lapse    -           ago     ELSE  select t from lapse  END  SQL   function timeSpanText  ts   conn      ts  date-time string   conn  PostgreSQL PDO connection    return  conn - gt  prepare DT SQL  - gt  execute  ts   - gt  fetchColumn

User · Answer

You ll have to take each individual piece of your timestamp  and convert it into Unix time  For example for the timestamp  2009-09-12 20 57 19      2008-1970  365   8 30  12  24 20 would give you a ROUGH estimate of the hours since January 1st  1970   Take that number  multiply by 60 and add 57 to get the minutes   Take that  multiply by 60 and add 19   That would convert it very roughly and inaccurately however   Is there any reason you can t just take the normal Unix time to begin with

User · Answer

function time elapsed string  ptime         etime   time   -  ptime       if   etime  lt  1                return  0 seconds               a   array  365   24   60   60    gt    year                    30   24   60   60    gt    month                         24   60   60    gt    day                              60   60    gt    hour                                   60    gt    minute                                    1    gt    second                          a plural   array   year      gt   years                           month     gt   months                           day       gt   days                           hour      gt   hours                           minute    gt   minutes                           second    gt   seconds                          foreach   a as  secs   gt   str                 d    etime    secs          if   d  gt   1                         r   round  d               return  r           r  gt  1    a plural  str     str      ago

User · Answer

i made this and it s working just fine it s working for both unix timestamp like 1470919932 or formatted time like 16-08-11 14 53 30  function timeAgo  time ago         time ago    strtotime  time ago    strtotime  time ago     time ago       time    time   -  time ago   switch  time      seconds case  time  lt   60  return  lessthan a minute ago      minutes case  time  gt   60  amp  amp   time  lt  3600  return  round  time 60     1     a minute    round  time 60    minutes ago      hours case  time  gt   3600  amp  amp   time  lt  86400  return  round  time 3600     1     a hour ago    round  time 3600    hours ago      days case  time  gt   86400  amp  amp   time  lt  604800  return  round  time 86400     1     a day ago    round  time 86400    days ago      weeks case  time  gt   604800  amp  amp   time  lt  2600640  return  round  time 604800     1     a week ago    round  time 604800    weeks ago      months case  time  gt   2600640  amp  amp   time  lt  31207680  return  round  time 2600640     1     a month ago    round  time 2600640    months ago      years case  time  gt   31207680  return  round  time 31207680     1     a year ago    round  time 31207680    years ago     endswitch       gt

User · Answer

I found results like the following ugly      1 years  2 months  0 days  0 hours  53 minutes and 1 seconds   Because of that I realized a function that respects plurals  removes empty values and optionally it is possible to shorten the output   function since  timestamp   level 6        global  lang       date   new DateTime         date- gt setTimestamp  timestamp        date    date- gt diff new DateTime            build array      since   array combine array  year    month    day    hour    minute    second    explode       date- gt format   y  m  d  h  i  s             remove empty date values      since   array filter  since          output only the first x date values      since   array slice  since  0   level          build string      last key   key array slice  since  -1  1  true         string           foreach   since as  key   gt   val               separator         if   string                 string     key     last key                 lang  and                               set plural          key     val  gt  1    s                   add date value          string     val          lang   key              return  string      Looks much better      1 year  2 months  53 minutes and 1 second   Optionally use  level   2 to shorten it as follows      1 year and 2 months   Remove the  lang part if you need it only in English or edit this translation to fit your needs    lang   array       second    gt   Sekunde        seconds    gt   Sekunden        minute    gt   Minute        minutes    gt   Minuten        hour    gt   Stunde        hours    gt   Stunden        day    gt   Tag        days    gt   Tage        month    gt   Monat        months    gt   Monate        year    gt   Jahr        years    gt   Jahre        and    gt   und

User · Answer

time ago         time   time   -  time     to get the time since that moment  tokens   array   31536000   gt   year  2592000   gt   month  604800   gt   week  86400   gt   day  3600   gt   hour   60    gt   minute  1   gt   second    foreach   tokens as  unit   gt   text    if   time  lt   unit continue   numberOfUnits   floor  time    unit    time ago        time ago   numberOfUnits      text    numberOfUnits gt 1   s             time    time    unit  echo  time ago

User · Answer

Just to throw in another option     Whilst I prefer the DateTime method posting here  I didn t like the fact it displayed 0 years etc          Returns a string stating how long ago this happened      private function timeElapsedString  ptime        diff   time   -  ptime       calc times   array         timeleft     array            Prepare array  depending on the output we want to get       calc times     array  Year      Years     31557600        calc times     array  Month     Months    2592000        calc times     array  Day       Days      86400        calc times     array  Hour      Hours     3600        calc times     array  Minute    Minutes   60        calc times     array  Second    Seconds   1        foreach   calc times AS  timedata           list  time sing   time plur   offset     timedata           if   diff  gt    offset                left   floor  diff    offset                diff -    left    offset                timeleft        left        left    1    time sing    time plur                        return  timeleft    time    gt   ptime   null    -     implode       timeleft    0

User · Answer

function humanTiming   time                          time   time   -  time     to get the time since that moment              time     time lt 1   1    time               tokens   array                   31536000   gt   year                   2592000   gt   month                   604800   gt   week                   86400   gt   day                   3600   gt   hour                   60   gt   minute                   1   gt   second                              foreach   tokens as  unit   gt   text                    if   time  lt   unit  continue                   numberOfUnits   floor  time    unit                   return  numberOfUnits      text    numberOfUnits gt 1   s                                 echo humanTiming  strtotime  mytimestring

User · Answer

Use of   echo elapsed time  2016-05-09 17 00 00       18 saat 8 dakika   nce yazildi    Function   function elapsed time  time     Nekadar zaman ge  mis           diff   time   - strtotime  time              sec    diff           min   floor  diff 60            hour   floor  diff  60 60             hour min   floor  min -   hour 60             day   floor  diff  60 60 24             day hour   floor  hour -   day 24             week   floor  diff  60 60 24 7             mon   floor  diff  60 60 24 7 4             year   floor  diff  60 60 24 7 4 12               difference calculate to string         if  sec  lt   60 5                return  simdi yazildi             elseif  min  lt  60               return  biraz   nce yazildi             elseif  hour  lt  24               return  hour   saat    hour min   dakika   nce yazildi             elseif  day  lt  7               if  day hour  0   day hour  day hour   saat    else  day hour                  return  day   g  n    day hour    nce yazildi             elseif  week  lt  4               return  week   hafta   nce yazildi             elseif  mon  lt  12               return  mon   ay   nce yazildi             else              return  year   yil   nce yazildi

[php] Converting timestamp to time ago in PHP e.g 1 day ago, 2 days ago...

Examples related to php

Examples related to timestamp