Jesper Andersson wrote:
Hello,
I relly new with databases and writing sql-questions.
But in my db want I to check what have new rows have come the last hour.
the db have I as follow:
ID email created updated 001 [EMAIL PROTECTED] 20050215131034 20050215133401
063 [EMAIL PROTECTED] 20050215141034 20050215141201
76 [EMAIL PROTECTED] 20050215134500 20050215134556
Now I would like to make a sql-question that show which new users have come the last hour, without that I need to edit the question each time I want to ask.
Please help!
- try using date_format and now(). See
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
- ian
-- +-------------------------------------------------------------------+ | Ian Sales Database Administrator | | | | "If your DBA is busy all the time... | | ...he's not doing his job properly" | | ebuyer http://www.ebuyer.com | +-------------------------------------------------------------------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
