5 messages in com.mysql.lists.win32RE: Sql syntax
FromSent OnAttachments
Phadnis, Vivek08 Jun 2004 11:24 
PF: MySQL08 Jun 2004 12:54 
Ângelo M. Rigo09 Jun 2004 07:26 
Bernard Clement09 Jun 2004 08:36 
Dean Urmson09 Jun 2004 08:45 
Subject:RE: Sql syntax
From:Dean Urmson (durm@mistral-networks.co.uk)
Date:06/09/2004 08:45:28 AM
List:com.mysql.lists.win32

data BETWEEN '2003-09-00 00:00:00' AND '2003-09-31 99:99:99'

My guess will be the hour/min/sec equal to 999999 or 99:99:99. Try with 235959 or 23:59:59 instead.

Also make it from the 1st of the month as BETWEENs are inclusive

data BETWEEN '2003-09-01 00:00:00' AND '2003-09-31 23:59:59' ^ ^^ ^^ ^^

Cheers

Dean