counting days in query

[Ike]

How can I make a query such that in the "WHERE" part of my clause, I want to
put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field.
I want to create a query asking for those rows where X days have elapsed
from the date field in a row and the boolean, say, is false.

Do I need to create a third field, called, say "X" for how many days have
elapsed between the date field and today, and update every row in the table
every day?

Thanks, Ike

[Aggro]

Ike wrote:

How can I make a query such that in the "WHERE" part of my clause, I want to
put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field.
I want to create a query asking for those rows where X days have elapsed
from the date field in a row and the boolean, say, is false.

http://www.mysql.com/doc/en/Date_and...functions.html

From the link above:

Here is an example that uses date functions. The following query selects
all records with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_co l) <= 30;

[Aggro]

Ike wrote:

How can I make a query such that in the "WHERE" part of my clause, I want to
put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field.
I want to create a query asking for those rows where X days have elapsed
from the date field in a row and the boolean, say, is false.

http://www.mysql.com/doc/en/Date_and...functions.html

From the link above:

Here is an example that uses date functions. The following query selects
all records with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_co l) <= 30;

[Ike]

Thank you. My problem is a little trickier however because my date's are not
date objects, but rather char[] representations of date objects (Strings),
i.e. '2003-12-28'

Is there a way I can convert the Strings to date objects within my query?

Thanks, Ike
"Aggro" <sp**********@y ahoo.com> wrote in message
news:_a******** ******@read3.in et.fi...

Ike wrote:

How can I make a query such that in the "WHERE" part of my clause, I want to put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field. I want to create a query asking for those rows where X days have elapsed
from the date field in a row and the boolean, say, is false.

http://www.mysql.com/doc/en/Date_and...functions.html

From the link above:

Here is an example that uses date functions. The following query selects
all records with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_co l) <= 30;

[Ike]

Thank you. My problem is a little trickier however because my date's are not
date objects, but rather char[] representations of date objects (Strings),
i.e. '2003-12-28'

Is there a way I can convert the Strings to date objects within my query?

Thanks, Ike
"Aggro" <sp**********@y ahoo.com> wrote in message
news:_a******** ******@read3.in et.fi...

Ike wrote:

How can I make a query such that in the "WHERE" part of my clause, I want to put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field. I want to create a query asking for those rows where X days have elapsed
from the date field in a row and the boolean, say, is false.

http://www.mysql.com/doc/en/Date_and...functions.html

From the link above:

Here is an example that uses date functions. The following query selects
all records with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_co l) <= 30;

[Ike]

Ah, I see now how to do it with strings!

...WHERE TO_DAYS(NOW()) - TO_DAYS(CAST(la ndondate AS DATE)) <= 10;

assuming landondate column of Strings!

Thank you, Ike

[Ike]

Ah, I see now how to do it with strings!

...WHERE TO_DAYS(NOW()) - TO_DAYS(CAST(la ndondate AS DATE)) <= 10;

assuming landondate column of Strings!

Thank you, Ike