How to calculate weeks elapsed in MySQL v4.0.25
Hi,
Can anyone provide an example of the most straight-forward way to determine if a datetime field in a table is from the future, the current week, last week, or the 3 months previous in MySQL v4.0.25? The TIMESTAMPDIFF function looks promising but it's only available in v5.0.
I'd like to pass something to the WHERE clause of the query.
Much thanks!
Ken.
Subject
Written By
Posted
How to calculate weeks elapsed in MySQL v4.0.25
August 06, 2005 03:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.