Re: [GENERAL] datetime problems

[Herouth Maoz]

At 13:50 +0200 on 21/10/98, Memphisto wrote:


> I'd like to issue a query that lists all the rows of a table whose 'date'
> columns(its type is datetime) is falls in a month, i.e. these rows were
> inserted in , say August. How can I do that?

SELECT *
FROM the_table
WHERE the_date BETWEEN '1998-08-01' AND '1998-08-31';



Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma