Re: help with sql query : DATETIME function

At 18:30 -0800 2/26/03, Admin-Stress wrote: I have a table with this structure : username VARCHAR(32) address VARCHAR(128) datereg DATETIME // date of registration classINT How is the sql query for username who are their datereg was 30 days ago and class = 1? WHERE class = 1 AN

help with sql query : DATETIME function

I have a table with this structure : username VARCHAR(32) address VARCHAR(128) datereg DATETIME // date of registration classINT How is the sql query for username who are their datereg was 30 days ago and class = 1? thanks __ D