<div>
Date/time values are stored as double precision numbers, where the decimal portion indicates the % of a day (12 hours = .5, 6 hours = .25, ...)<br />
<br />
so, if you want to pass seconds, you need to convert those to portions of a day.<br />
<br />
WHERE [ColumnNameT1] &lt;&nbsp;[X]/60/60/24 AND [ColumnNameT2] &gt;&nbsp;[X]/60/60/24<br />
<br />
In this example, [X] is a parameter that you would be asked for when you run your query.
</div>


<div>
Hi fyed!<br />
expression = &quot;(&quot; + dMyPos / 60 / 60 / 24 + &quot;&nbsp;&gt; TBeg) &nbsp;and ( &quot;&nbsp;+ dMyPos / 60 / 60 / 24 + &quot;&nbsp;&lt; TEnd ) and ( &quot;&nbsp;+ dMyPos / 60 / 60 / 24 + &quot;&nbsp;&gt; 0) and (FilmID = &quot;&nbsp;+ myFilm.FilmID.ToString() + &quot;)&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
equates to:<br />
(0,000814913194444445 &gt;&nbsp;TBeg) &nbsp;and ( 0,000814913194444445 &lt;&nbsp;TEnd ) and ( 0,000814913194444445 &gt;&nbsp;0) and (FilmID = 1)<br />
<br />
Out of this simple filter I get <br />
Syntax error in expression<br />
<br />
Any explanation for that?
</div>


<div>
It appears that you are using .Net, I would recommend that you add that zone to your list of zones by clicking the &quot;request attention&quot; hyperlink in the bottom right corner of your original post.<br />
<br />
I'm not sure why you need the third expression in this expression. &nbsp;if dMyPos is a positive value (# of seconds) then the expression: dMyPos/60/60/24 is always going to be greater than zero.<br />
<br />
Are TBeg, TEnd, and FilmID all fields in a table?<br />
<br />
How are you using this expression in the rest of your code?
</div>


<div>
Your right about the third expression.<br />
Yes, TBeg, TEnd and FilmID are fields in a table. <br />

<pre><code class="code-1 nolinks" id="code-20-36906009-1"><span>             expression = &quot;(&quot; + dMyPos / 60 / 60 / 24 + &quot; &gt; [TBeg])  and ( &quot; + dMyPos / 60 / 60 / 24 + &quot; &lt; [TEnd] ) and ( &quot; + dMyPos / 60 / 60 / 24 + &quot; &gt; 0) and (FilmID = &quot; + myFilm.FilmID.ToString() + &quot;)&quot;;</span>
<span>                DataRow[] foundRows;</span>
<span>                foundRows = dt_Tags.Select(expression);</span>
<span>                newitem.Clear();</span>
<span>                foreach (DataRow dr in foundRows)</span>
<span>                {...</span>
</code></pre>
</div>


<div>
What language is this?<br />
<br />

</div>


<div>
You might want to ask the moderators to add the c# zone to your question. &nbsp;Use the request attention hyperlink in the bottom right corner of your original post.
</div>


<div>
1. Your regional settings use commas instead of periods. &nbsp;Try this to see if it is acceptable to the database engine:<br />

<pre><code class="code-1 nolinks" id="code-20-36916210-1"><span>(0.000814913194444445 &gt; TBeg)  and ( 0.000814913194444445 &lt; TEnd ) and ( 0.000814913194444445 &gt; 0) and (FilmID = 1)</span>
</code></pre>
<br />
2. The simpler formula to convert seconds-past-midnight into a time value is to divide by the number of seconds in a day (86400).
</div>


<div>
Aikimark, I have a hunch you may be right - but how do I change the culture for just this line of code?<br />

</div>


<div>
What value displays if you use a .tostring() method to the expression?<br />
<br />
You should test my hypothesis with a hard-coded literal expression that uses a period instead of a comma. &nbsp;Pick any time value expressed in seconds. &nbsp;Divide that by 86400 and type that into your .Select() expression. &nbsp;Does it execute?
</div>


<div>
Thank you.<br />
<br />
Although I changed the &quot;,&quot; to &quot;.&quot; via string replace- that didn't help. <br />
<br />
The solution that works is to create an aggregate column that does the division by 86400 in the dataset creation and use that column for value comparison.
</div>


<div>
<div class="content wysiwyg-content">
I have a dataset with datetime columns in which there are only h:mm:ss. I would like to filter the dataset where a value would be between to column values. <br />
<br />
x &gt;&nbsp;T1 and x &lt;&nbsp;T2<br />
<br />
the x value is given in integer, representing a number of seconds.<br />
<br />
expression = &quot;x &gt;&nbsp;columnNameT1 and x &lt;&nbsp; columnNameT2&quot;;<br />
DataRow[] foundRows;<br />
foundRows = dt_Tags.Select(expression)<wbr /><br />
How would expression look like?<br />
Thanks
</div>
</div>


I have a dataset with datetime columns in which there are only h:mm:ss. I would like to filter the dataset where a value would be between to column values. 

x > T1 and x < T2

the x value is given in integer, representing a number of seconds.

expression = "x > columnNameT1 and x <  columnNameT2";
DataRow[] foundRows;
foundRows = dt_Tags.Select(expression)
How would expression look like?
Thanks

How to Filter Times in a Dataset

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.