javascript、php与mysql时间格式化函数

1. javascript：

   /*
   @desc：时间友好显示函数
   @param stamp 时间缀，10位长度
   */
   function timefriend(stamp){
   this.stamp = stamp
   /*
    @desc：主方法，执行转换
    */
   this.get = function(){
       var stamp = this.stamp
       if(!stamp){
           return '—';
       }
       var date = new Date(stamp*1000)
       var time = Math.round(new Date().getTime()/1000)
       diff = time - stamp
       if(diff<0){
           return '—';
       }else if(diff<60){
           return diff+'秒前'
       }else if(diff<3600){
           return Math.floor(diff/60)+'分钟前'
       }else if(diff<86400){
           return Math.floor(diff/3600)+'小时前'
       }else if(diff<259200){
           return Math.floor(diff/86400)+'天前'
       }else{
           var year = this.parsetime(date.getFullYear())
           var month = this.parsetime(date.getMonth())
           var day = this.parsetime(date.getDate())
           var hour = this.parsetime(date.getHours())
           var minute = this.parsetime(date.getMinutes())
           var second = this.parsetime(date.getSeconds())
           var ret = year+'-'+month+'-'+day+' '+hour+':'+minute+':'+second
           return ret
       }
   }
   this.parsetime = function(input){
       var ret
       if(input >= 0 && input < 10){
           ret = '0'+input
       }else{
           ret = input
       }
       return ret
   }
   }
   var timefriend = new timefriend('1428593779')
   console.log(timefriend.get())

2. php：

   /*
   @desc：显示某一个时间相当于当前时间在多少秒前，多少分钟前，多少小时前
   @param  stamp      时间戳
   @param  format     时间显示格式，默认Y-m-d H:i:s
   @return 如      5秒前
   */
   function timefriend($stamp,$format = 'Y-m-d H:i:s'){
   if(empty($stamp)||!is_numeric($stamp)||!$stamp){
       return '—';
   }
   $diff = time() - $stamp;
   if($diff<0){
       return '—';
   }elseif($diff<60){
       return $diff.'秒前';
   }elseif($diff<3600){
       return floor($diff/60).'分钟前';
   }elseif($diff<86400){
       return floor($diff/3600).'小时前';
   }elseif($diff<259200){
       return floor($diff/86400).'天前';
   }else{
       return date($format,$stamp);
   }
   }

3. mysql：

   DELIMITER //
   CREATE FUNCTION friendlyDate(sTime char(11))
   RETURNS char(11)
   BEGIN
   if sTime='' then
       return '-';
   end if;
   set @cTime=UNIX_TIMESTAMP();
   set @dTime=@cTime-sTime;
   set @dDay=DATE_FORMAT(@cTime,'%e')-DATE_FORMAT(@sTime,'%e');
   set @dYear=DATE_FORMAT(@cTime,'%Y')-DATE_FORMAT(@sTime,'%Y');
   if @dTime>0 then
       if @dTime<60 then
           if @dTime<10 then
               return '刚刚';
           else
               set @t=floor(@dTime/10)*10;
               set @ret=concat(@t,'秒前');
               return @ret;
           end if;
       elseif @dTime<3600 then
           set @t=@dTime/60;
           set @ret=concat(@t,'分钟前');
           return @ret;
       elseif @dYear=0 && @dDay=0 then
           set @t=DATE_FORMAT(@sTime,'%H:%i');
           set @ret=concat('今天',@t);
           return @ret;
       elseif @dYear=0 then
           return DATE_FORMAT(@sTime,'%m月%d日 %H:%i');
       else
           return DATE_FORMAT(@sTime,'%Y-%m-%d %H:%i:%s');
       end if;
   else
       return DATE_FORMAT(@sTime,'%Y年%m月%d日 %H:%i');
   end if;
   END
   //
   DELIMITER ;