List:General Discussion« Previous MessageNext Message »
From:Alex Schajer Date:April 15 1999 10:18am
Subject:Previous Days using CURADTE()
View as plain text  
When I:

SELECT CURDATE();
	1999-04-15 
SELECT CURDATE()-1;
	19990414
However when I:
SELECT CURDATE()-16;
	19990399

The problem appears when the number of days being deducting from curdate is
greater than the number of days in that month.

Is there a safe way of going back in time?

Thanks,

Alex Schajer
Thread
• Previous Days using CURADTE()Alex Schajer15 Apr
  • Re: Previous Days using CURADTE()Aldrian Gintingsuka15 Apr
• Re: MySQL transaction problem (Again...)Carfield Yim11 Jan
  • Re: MySQL transaction problem (Again...)Tomi Junnila11 Jan
• RE: MySQL transaction problem (Again...)Richard RE SSI-GRAX Mehalick11 Jan