error calculating datetime

2007-01-20T14:11:21-04:00

Any idea how i can insert that into the script?

script us

Code:

set data [mysqlsel $db "select *,SEC_TO_TIME(unix_timestamp(now()) - unix_timestamp(pretime)) as data from $table WHERE nick like '%$keyed%' GROUP BY data;" -list]

to calculate the time difference between addtime and time now.

Statistics: Posted by heman — Sat Jan 20, 2007 2:11 pm

error calculating datetime

2007-01-20T10:55:28-04:00

To calculate the time difference between addtime and time now, use:

Code:

duration [expr {[unixtime]-[clock scan ]}]

example:

.tcl duration [expr {[unixtime]-[clock scan "2007-01-17 20:11:43"]}]
Tcl: 2 days 20 hours 42 minutes 50 seconds

Statistics: Posted by Sir_Fz — Sat Jan 20, 2007 10:55 am

error calculating datetime

2007-01-20T10:39:45-04:00

While testing the script, i found a problem

The script I use, stores nicks with date and time in mysql db

The row, thats stores date now, is called addtime:

Made it like this: 'addtime datetime'

This row stores datetime like this

2007-01-17 20:11:43

The script uses:

Code:

set data [mysqlsel $db "select *,SEC_TO_TIME(unix_timestamp(now()) - unix_timestamp(pretime)) as data from $table WHERE nick like '%$keyed%' GROUP BY data;" -list]

To calculate time between addtime and time now.

This will result in a output in hours, minutes and seconds. Example: 65:57:17

So the output looks someting like this:

DATA -> NICK {2007-01-17 20:11:43} 65:57:17

In the earlier post (http://forum.egghelp.org/viewtopic.php?t=12983) i asked to change the time output (65:57:17) to seconds, minutes, hours, days etc

Code:

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

That worked, so it announce in the irc channel someting like this:

NICK - Added 2 days 17 hours 57 minutes 7 seconds ago

So everyting works great

But now the problem:

When a nick is added longer then about 4 weeks 6 days 22 hour 59 minutes and 59 seconds ago (838:59:59), it keeps announcing 4 weeks 6 days 22 hour 59 minutes and 59 seconds (838:59:59) even if the nick is added longer then that time ago.

data Examples:

DATA -> nick1 {2006-11-19 18:46:13} 838:59:59
DATA -> nick2 {2006-11-22 01:59:23} 838:59:59
DATA -> nick3 {2006-11-27 09:22:19} 838:59:59

So the addtime is correct, but the calculated time between addtime and now time isnt, it keep telling its 838:59:59 (?)

Any idea what could be the problem?

Thanks

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

egghelp/eggheads community

error calculating datetime

error calculating datetime

error calculating datetime