CyberArmy Academy | CyberArmy Services & Support | Open Source Institute | CyberArmy Intelligence & Security | CyberArmy Projects

RE: Person Counter Script


[Replies] [Reply] [View by Thread] [Help]
[Back To Programming]

Posted by Ret. Lambda Gen Goldfish On 2008-05-15 00:56:31
In Reply to RE: Person Counter Script Posted by Gamma Cpt ranok On 2008-05-11 12:56:38

Ret. Lambda GenRet. Lambda Gen
Ret. Lambda Gen Goldfish


There's a lot of stuff built into mySQL for such purposes. Have a look around:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

You'll find most of these functions are worth having a reasonable knoweldge of cause they seem to be required more often than you'd think...

P

On 2008-05-11 12:56:38, ranok wrote
>You can do a mktime to make a timestamp for say noon on May 2nd, and then select all timestamps that are 12 hours before or after that to get all emplyees from that day.

Lambda General Goldfish
- Dinah Coder
- Chief Sered 'BOFH' Admin


Replies:


Guest:
Subject:
Message:
Signature:
Optional Image Link:
http://

CyberArmy::Forum v0.6
Generated In 0.01817 seconds


About Us | Privacy Policy | Mission Statement | Help