<div>
and you can use<br />
<br />
abs(datediff(minute, date1, date2)) &lt;= 2<br />
<br />
to find the interval
</div>


and you can use

abs(datediff(minute, date1, date2)) <= 2

to find the interval

<div>
Thanks to all! Although not exactly what I was looking for but they gave me enough insights to solve my query problem!<br />
sew
</div>


Thanks to all! Although not exactly what I was looking for but they gave me enough insights to solve my query problem!
sew

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
What SQL query syntax should I use to retrieve all records where the processed time is within two minutes? There's a twist: my processed time field is a text field in this format YYYYMMDDHHNNSS (e.g. 20111006114320). I need to select all records where the process time is within two minutes of a specific.<br />
<br />
For example, if the current process time is 11:43:20 (20111006114320), then records with these time value should be selected:<br />
11:43:20<br />
11:43:19<br />
11:43:18<br />
<br />
This should NOT be selected:<br />
11:43:17<br />
11:43:21<br />
<br />
The SQL query syntax needs to work in both MS Access and SQL Server<br />
<br />
Thanks in advance!<br />
sew<br />

</div>
</div>


Experts,

What SQL query syntax should I use to retrieve all records where the processed time is within two minutes? There's a twist: my processed time field is a text field in this format YYYYMMDDHHNNSS (e.g. 20111006114320). I need to select all records where the process time is within two minutes of a specific.

For example, if the current process time is 11:43:20 (20111006114320), then records with these time value should be selected:
11:43:20
11:43:19
11:43:18

This should NOT be selected:
11:43:17
11:43:21

The SQL query syntax needs to work in both MS Access and SQL Server

Thanks in advance!
sew


SQL query syntax help on time comparison from text string

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.