[RESOLVED] How to select like on a parametized sqlcecommand?

[jmcilhinney]

You can't use LIKE with any data type other than text. You can only use things like =, < and > for dates. In this situation you have two choices:

1. Use a database function to remove the time from the date/time column value.
2. Use two date parameters a day apart.

The first option would look something like this:

WHERE DateFunction(MyDateTimeColumn) = @MyDateParameter

There is no actual DateFunction function. You'd have to check the documentation for your database to see if a function that does that exists.

Here's an example of the second option to get all records with yesterday's date:

myCommand.CommandText = "SELECT * FROM MyTable WHERE MyDateTimeColumn >= @StartDate AND MyDateTimeColumn < @EndDate";
myCommand.Parameters.AddWithValue("@StartDate", DateTime.Today.AddDays(-1))
myCommand.Parameters.AddWithValue("@EndDate", DateTime.Today)

You could probably also use BETWEEN but I can never remember which limits are inclusive and which are exclusive.

[Legendary_Agent]

You can't use LIKE with any data type other than text. You can only use things like =, < and > for dates. In this situation you have two choices:

1. Use a database function to remove the time from the date/time column value.
2. Use two date parameters a day apart.

The first option would look something like this:

WHERE DateFunction(MyDateTimeColumn) = @MyDateParameter

There is no actual DateFunction function. You'd have to check the documentation for your database to see if a function that does that exists.

Here's an example of the second option to get all records with yesterday's date:

myCommand.CommandText = "SELECT * FROM MyTable WHERE MyDateTimeColumn >= @StartDate AND MyDateTimeColumn < @EndDate";
myCommand.Parameters.AddWithValue("@StartDate", DateTime.Today.AddDays(-1))
myCommand.Parameters.AddWithValue("@EndDate", DateTime.Today)

You could probably also use BETWEEN but I can never remember which limits are inclusive and which are exclusive.

Even better than what i wanted, thank you so much, i cant semm to add rep right now but as soon as i "spread" enough rep ill add it asap.
Thanks again