Re: Selecting a date

2003-09-27 Thread Paul DuBois
At 11:02 -0400 9/27/03, Bruce Therrien wrote: Using a select statement, how does one select all records that have a date one day less than the current date? Searching the archives and I can't seem to find the answer.. Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in forma

Re: Selecting a date

2003-09-27 Thread Hassan Schroeder
Bruce Therrien wrote: Using a select statement, how does one select all records that have a date one day less than the current date? Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in format 00/00/ Gack. I'm guessing "00/00/" is a string? 1) "DATE" is a MySQL reserve