I need to filter on a TimeSpan column

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

My table has a TimeSpan column. I need to filter it to find all rows
between two times. Say midnight to noon (00:00:00) to (12:00:00)

A filter expression for a date is: string filter = "mycolumn = #" +
mydatetime + "#". This doesn't work for TimeSpans.

The syntax for strings and numbers also don't work.

The only thing I can come up with is filter = "Convert(myTimeColumn,
System.String) = '" + mytime + "'";
and I am not sure about that either.

Any one have any ideas?

Chuck
 
No. I mean System.TimeSpan. It can be used to indicate time of day
without knowing the date.

Chuck
 
Hi Chuck,

Sorry; I thought you were referring to sql server, but it's simply a vb .net
type.

Bernie
 
Back
Top