<div>
Select * From tablename where DateDiff(second, datetimecolumne, getdate()) &lt;= 30
</div>


Select * From tablename where DateDiff(second, datetimecolumne, getdate()) <= 30

<div>
<a href="http://msdn.microsoft.com/en-us/library/ms189794.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms189794.aspx</a>
</div>


http://msdn.microsoft.com/en-us/library/ms189794.aspx [http://msdn.microsoft.com/en-us/library/ms189794.aspx]

<div>
I'm getting a conversion failed when &nbsp;converting time to char string. &nbsp;Here is the query im using.<br />
<br />
Select * From dbo.Workstations where DateDiff(second, CHECKTIME, getdate()) &lt;= 30<br />
<br />
The time in i have in my cell is in the following format. &nbsp;12/13/2011 9:42:27 AM
</div>


I'm getting a conversion failed when  converting time to char string.  Here is the query im using.

Select * From dbo.Workstations where DateDiff(second, CHECKTIME, getdate()) <= 30

The time in i have in my cell is in the following format.  12/13/2011 9:42:27 AM

<div>
I have you haven't stored the timestamp in a text field, but that is what it looks like.
</div>


I have you haven't stored the timestamp in a text field, but that is what it looks like.

<div>
Well I found that a bunch of them did not have a time stamp yet, so I changed the query to just look at one row, but I'm not sure of the syntax. &nbsp;Here is what I have, but it's not right. &nbsp;I just want it to check one row<br />
<br />
Select * From dbo.Workstations where DateDiff(second, CHECKTIME, getdate()) &lt;= 30, SERIAL=234454345
</div>


Well I found that a bunch of them did not have a time stamp yet, so I changed the query to just look at one row, but I'm not sure of the syntax.  Here is what I have, but it's not right.  I just want it to check one row

Select * From dbo.Workstations where DateDiff(second, CHECKTIME, getdate()) <= 30, SERIAL=234454345

<div>
<div class="content wysiwyg-content">
I need to find all the rows in my data base that have a timestamp within the last 30 seconds. &nbsp;One of my columns contains a timestamp in this format 12/13/2011 9:42:27 AM. &nbsp;I need to find all rows that have a time stamp within the last 30 seconds. &nbsp;How can I do this with an sql command?
</div>
</div>


I need to find all the rows in my data base that have a timestamp within the last 30 seconds.  One of my columns contains a timestamp in this format 12/13/2011 9:42:27 AM.  I need to find all rows that have a time stamp within the last 30 seconds.  How can I do this with an sql command?

compare times with sql

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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,