Thanks everyone for their help!
Max Clark [EMAIL PROTECTED] wrote in message
av2eai$8he$[EMAIL PROTECTED]">news:av2eai$8he$[EMAIL PROTECTED]...
Hi all,
I have a DATE column (CCYY-MM-DD), I would like to do a query like this:
select * from table where date = '2003-01'
What additional
Hi Max,
You must enter this:
SELECT * FROM your_table WHERE date LIKE 2003-01-%;
I think that you can more read about LIKE at http://www.mysql.org
Best Regards,
Boris Penchev
- Original Message -
From: Max Clark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003
On 2 Jan 2003, at 14:27, Max Clark wrote:
I have a DATE column (CCYY-MM-DD), I would like to do a query like this:
select * from table where date = '2003-01'
What additional information do I need to provide for this query to work
properly?
You need to explain to us what result you
On Thu, 2 Jan 2003 14:27:25 -0800, Max Clark wrote:
select * from table where date = '2003-01'
aside from ...where (date='2003-01-01' and date = '2003-01-31') I
think you could use ...where left(date,7) = '2003-01'
http://www.mysql.com/doc/en/Date_calculations.html
- Steve Yates
- To know
I think you could also use:
WHERE YEAR(date) = 2003
AND MONTH(date) = 01
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 5:09 PM
To: [EMAIL PROTECTED]
Cc: Max Clark
Subject: Re: Select Date Help
On 2 Jan 2003, at 14
* Tom Jones
I have a table with 2 columns StartDate and EndDate.
I can't seem to figure out how to write a select statement that will
tell me if the date I'm searching on is between the Start and the End
date.
Like, I want to know if 7/4/2002 is between 6/1/2002 (startDate) and
8/1/2002
On Wednesday, June 5, 2002, at 10:03 PM, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
