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