egghelp/eggheads community

convert timeago mysql

2007-01-20T10:41:27-04:00

that worked

Thanks.

But now I have an other problem while testing the script

So please take a look at:
http://forum.egghelp.org/viewtopic.php?p=69757#69757

Thanks

Statistics: Posted by heman — Sat Jan 20, 2007 10:41 am

convert timeago mysql

2007-01-19T19:23:25-04:00

Code:

proc timeAgo t { foreach {h m s} [split $t :] {  set unixt [clock scan "$h hours $m minutes $s seconds ago"]  break } duration [expr {[unixtime]-$unixt}]}

« Opposing » .tcl proc timeAgo t {foreach {h m s} [split $t :] {set unixt [clock scan "$h hours $m minutes $s seconds ago"];break} ; duration [expr {[unixtime]-$unixt}]}
« Bot » Tcl:
« Opposing » .tcl timeAgo 339:50:57
« Bot » Tcl: 2 weeks 3 hours 50 minutes 57 seconds

Statistics: Posted by Sir_Fz — Fri Jan 19, 2007 7:23 pm

convert timeago mysql

2007-01-19T18:43:34-04:00

I need some help, i search around this forum, but couldnt find what im looking for.

Here goes:

Nicks are stored in a mysql database with the time the nick is added (datetime) like: 2007-19-01 20:01:02 (row is called "addtime")

To find how long ago the nick was stored the script use the folowing:

Code:

 set temp [mysqlsel $db "select *,SEC_TO_TIME(unix_timestamp(now()) - unix_timestamp(addtime)) as data from table WHERE .....

Now it returns someting like:

nick added to the db 17:50:57 ago
nick added to the db 25:50:57 ago
nick added to the db 339:50:57 ago
etc.

Im trying it will return the time after 24:00:00 like 1day 1hour 50min and 57 sec ago.

Same with weeks ,months, years

Any idea what i can add to the script to let it announce like this?

Thanks.

Statistics: Posted by heman — Fri Jan 19, 2007 6:43 pm