CURDATE()

[Crustyfur]

Hi guys,

 

I am currently using a simple CURDATE() in my query: fdate > CURDATE()

 

Is there a way of making it +1 day? At the moment it is updating the data 24 hours before I want it too.

 

Cheers

 

Chris

[georg]

Here is the simplest way I could think of at the moment:

SELECT DATE( CURDATE() + 1 )

[Crustyfur]

Thanks Georg,

 

That worked but I had to change the +1 to -1  ??? Works though

 

Cheers

[bubblegum.anarchy]

SELECT adddate(CURRENT_DATE, INTERVAL 1 DAY);

[fenway]

Here is the simplest way I could think of at the moment:

SELECT DATE( CURDATE() + 1 )

Very, very bad -- always use interval, or something equivalent... I prefer "CURDATE() + INTERVAL 1 DAY".

[bubblegum.anarchy]

wow, I did not know that the following is possible:

 

SELECT CURRENT_DATE + INTERVAL 1 DAY;

[fenway]

wow, I did not know that the following is possible:

 

SELECT CURRENT_DATE + INTERVAL 1 DAY;

Yes, it's absolutely wonderful, no more unnecessary functions and parens lying everywhere.