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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-23 : 09:06:49
|
| hema writes "Suppose i have a table which holds the reservation done for a month.How do i retrive all the reservations for a week based on the current date?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-23 : 09:58:54
|
| what is "a week based on the current date" ?From midnight 7 days ago until now?Or from midnight last Sun/Mon to now? (or some other week-start-day?)Or from same time as right now, but 7 days ago, until now?Kristen |
 |
|
|
|
|
|
Date Query