List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:March 31 2011 10:52am
Subject:Strange date behaviour
View as plain text  
Hi,

Mysql > select curdate() + interval 6 month - interval 6 month;
+-------------------------------------------------+
| curdate() + interval 6 month - interval 6 month |
+-------------------------------------------------+
| 2011-03-30                                      |
+-------------------------------------------------+
1 row in set (0.00 sec)

Any ideas why this is wrong?

Andrew

-----------------------------------------------------------------------------------------------------------------------------------------
LOVEFiLM UK Limited is a company registered in England and Wales. 
Registered Number: 06528297. 
Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom.

This e-mail is confidential to the ordinary user of the e-mail address to which it was
addressed. If you have received it in error, 
please delete it from your system and notify the sender immediately.

This email message has been delivered safely and archived online by Mimecast.
For more information please visit http://www.mimecast.co.uk 
-----------------------------------------------------------------------------------------------------------------------------------------
Thread
Strange date behaviourAndrew Braithwaite31 Mar
  • Re: Strange date behaviourRoy Lyseng31 Mar