24 Feb
2010
24 Feb
'10
4:06 p.m.
On 24/02/10 15:41, Martin A. Brooks wrote:
postgres=# select '2009-02-28'::date+'1 day'::interval; ?column?
2009-03-01 00:00:00 (1 row)
Perhaps mysql has a similar function?
SELECT '2009-02-28' + INTERVAL 1 DAY;
Or, for James: SELECT blah, blah, blah FROM tblBlah WHERE date_entered BETWEEN '2010-01-01' AND '2010-01-28' + INTERVAL 1 DAY
Note the date format; when I tried it, MySQL didn't do a great job of interpretting '28/01/2010'.
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450
Registered in England (0456 0902) @ 13 Clarke Rd, Milton Keynes, MK1 1LG