List:General Discussion« Previous MessageNext 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 functionAdmin-Stress27 Feb
  • Re: help with sql query : DATETIME functionPaul DuBois27 Feb