egghelp/eggheads community

Posted: **Thu Mar 02, 2006 1:32 am**

hey Fellow TCLers

i have a question

ill need to count out from unixtime in the db and find count of adds for the current day..
how can i do that ?

Posted: **Fri Mar 03, 2006 1:19 am**

not a Tcl question, but anyway:

SELECT COUNT(stuff) FROM sometable WHERE FROM_UNIXTIME(timestamp, '%Y-%m-%d') = CURDATE()

mysqltcl help