This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

mysqltcl help

Website and forum-related announcements and discussion, and anything else that doesn't fit in the above forums.
Post Reply
B
B3aVeR
Voice
Posts: 3
Joined: Mon Jan 16, 2006 11:50 am

mysqltcl help

Post by B3aVeR »

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 ?
User avatar
demond
Revered One
Posts: 3073
Joined: Sat Jun 12, 2004 9:58 am
Location: San Francisco, CA
Contact:

Post by demond »

not a Tcl question, but anyway:

Code: Select all

SELECT COUNT(stuff) FROM sometable WHERE FROM_UNIXTIME(timestamp, '%Y-%m-%d') = CURDATE()
connection, sharing, dcc problems? click <here>
before asking for scripting help, read <this>
use

Code: Select all

 tag when posting logs, code
Post Reply