Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Date in SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-01 : 11:14:52
manoq writes "How to write a sql statement if you want to select records that the date for the records is more than 7 days form the current date.

select *
from my_table
where [different between record_date and current_date is more than 7 days]

Please help me...i really this sql statement..."
   

- Advertisement -