<div>
maybe because the native datatype for SQL is datetime or smalldatetime. which means that you need to pass the Date portion instead of just the time. so instead of placing &quot;10:59a&quot;, it should be something like &quot;05/04/2005 10:59am&quot;. 
</div>


maybe because the native datatype for SQL is datetime or smalldatetime. which means that you need to pass the Date portion instead of just the time. so instead of placing "10:59a", it should be something like "05/04/2005 10:59am".

<div>
<div class="content wysiwyg-content">
Hi, All!<br />
The problem is I'm trying to move my data from Excel spreadsheet to &nbsp;MS SQL DB.<br />
It's very important to keep data clean, so I need validate some columns, one of them time <br />
Let say time is 10:59a<br />
IsDate(&quot;10:59a&quot;) = true<br />
But it's wrong, SQL Server won't accept it.<br />
Any ideas how to validate time like that.
</div>
</div>


Hi, All!
The problem is I'm trying to move my data from Excel spreadsheet to  MS SQL DB.
It's very important to keep data clean, so I need validate some columns, one of them time 
Let say time is 10:59a
IsDate("10:59a") = true
But it's wrong, SQL Server won't accept it.
Any ideas how to validate time like that.

Time validation (IsTime)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.