First get a real email address if you want real replies.

On Fri, 27 Jun 2003 20:54:25 -0400, Albert <donotcontact@this.address> wrote:
> It is the MySql DATE type. looks like (DD-MM-YYYY).
^^^^^^^^^^
This isn't a MySQL date format.


select * from mydatabase where datefield like "2003-07%";

This works for me.


>
> "Steven James Samuel Stapleton" <stapleton.41@mps.ohio-state.edu> wrote in
> message news:mcgHx12drhfu@ohstpy...
>> What format is the date field stored in?
>>
>> Is there a day, month, and year field (separate)?
>> Is it a timestamp?
>> Is it something else?
>>
>> -Jim Stapleton
>>
>> "Albert Ahtenberg" <donotcontact@this.address> wrote in message
>> news:bdhud4$tev$1@tabloid.uwaterloo.ca...
>> > Hi,
>> >
>> > I have a database with a date field. And I would like to see the report
>> > grouped by a ceratin month and year, how can I do that without multiple
>> > queries?
>> >
>> > Albert Ahtenberg
>> >
>> >
>>
>>
>
>


--
Michael Vore, W3CCV M-ASA [Ka8]; WHIRL, ABC; CAW, CW, AAW
http://mike.vorefamily.net/ohmywoodness <-Custom Woodworking
http://mike.vorefamily.net/thewoodenradio <-The weblog