DateTime Filter Expression

  • Thread starter Thread starter sdfsdfds
  • Start date Start date
S

sdfsdfds

Hi, is there anyway of selecting rows with a particular date but ignoring
the time within a date time column?

something like...
DataTable.Select("DateTimeColumn".Date = '28/12/06')

?

thanks in advance for any advice.

Sharat Koya
 
I did think that I could select a date between "27/12/06 23:59:59" and

"28/12/06 23:59:59".

Or could this work as a neater solution and does it depend upon culture?

DataTable.Select("DateTimeColumn.Date = #28/12/06#") ??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataBinding to a combo box. 3
How to Get Year/Month/Date of a DateTime Column by Column.Expressi 2
Wrong time to datetime conversion using ODBC - who am I to blame? 6
Basic Binding and Filtering Problem 6
ADO filter 2
Using DataView.RowFilter with DateTimes including both date and time data 1
DataTable search performance 2
problem with DataTable.Select 3

Back
Top