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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare Dates

Status
Not open for further replies.
bxgirl

bxgirl

Programmer
Nov 21, 2005
75
US
Using mysql 4.0, which doesn't support DATEDIFF

I'd like to compare two dates and check if the difference is 6 weeks or greater. How can I do this?

Thanks in advance.

bxgirl
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
413
EdLentz
EdLentz
C_C_K
  • Locked
  • Question
return groupod by dates from subquery 1
Replies
8
Views
174
feherke
feherke
vacunita
  • Locked
  • Question
str_to_date for dates in other languages
Replies
1
Views
137
vacunita
vacunita
kernal
  • Locked
  • Question
Need to Calculate an Expiration Date depending on Purchase Dates for a Membership
Replies
0
Views
55
kernal
kernal
mrbti
  • Locked
  • Question
Compare Two Tables
Replies
4
Views
43
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top