MySQL Lists: mysql: help with sql query : DATETIME function

List:	General Discussion	« Previous Message Next Message »
From:	Admin-Stress	Date:	February 27 2003 2:30am
Subject:	help with sql query : DATETIME function
View as plain text

I have a table with this structure :

  username VARCHAR(32)
  address  VARCHAR(128)
  datereg  DATETIME      // date of registration
  class    INT

How is the sql query for username who are their datereg was 30 days ago and class = 1? 

thanks

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

Thread
• help with sql query : DATETIME function	Admin-Stress	27 Feb
• Re: help with sql query : DATETIME function	Paul DuBois	27 Feb