
May 31st, 2000, 06:25 AM
|
 |
.Net Developer
|
|
Join Date: Feb 2000
Location: London
Posts: 987
Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14
|
|
i guess you are using this for a mysql query.
if it is for mysql query then use TO_DAYS() for doing it .
"SELECT field1,field2 FROM tbl_name WHERE TO_DAYS(now())-TO_DAYS(datefield)=7";
------------------
SR -
shiju.dreamcenter.net
"The fear of the LORD is the beginning of knowledge..."
|