Ignoring milliseconds in a filter expression for datatable.select method

Question

0.00/5 (No votes)

See more:

Hi all,

I have datatable, in that have one datetime column (CreateOn). These values like 2012-10-13 13:30:11.563. Now I want write a filter expression for getting values on CreatedOn column with out milliseconds with help of DataTable.Select() method. Is it possible.

Posted 16-Oct-12 19:03pm

Narra sreenu

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anandkumar D · Accepted Answer · 2012-10-16T19:33:00

Solution 1

yes its possible, Do like this

C#

DataRow[] dr = dt.Select("CreateOn LIKE '2012-10-13*'");

Posted 16-Oct-12 19:33pm

Anandkumar D

Ignoring milliseconds in a filter expression for datatable.select method

1 solution

Solution 1

Add your solution here

Preview 0

Ignoring milliseconds in a filter expression for datatable.select method

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us