custom time requiement (develop a time advance method)

I need to develop a time advance method by minutes,hours and days for testing purposes.please could any one can give me an idea to do this .

please please help me or give me a reference please

If I understand your need you can use ADDDATE and ADDTIME...

More info at:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

Posting a clear example of what you are asking for would also help folks assist you more easily.