Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to query the data exist 52 weeks from today?

Status
Not open for further replies.
cooperchien

cooperchien

MIS
Sep 21, 2004
108
US
I have a database which has the date column. I am having trouble to come out with a query that can select the data which exists 52 weeks from today.
Please help. thanks.
 
Sort by date Sort by votes
what are you using to do the query? have you tried the mysql date_sub functions?

How is your query structured?

Bastien

Cat, the other other white meat
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
553
EdLentz
EdLentz
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
412
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
452
EdLentz
EdLentz
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
136
Arthur Lewis
Arthur Lewis
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
449
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top