<div>
Hi,<br />
<br />
The vb.net datatype equivalent for &nbsp;Time datatype of sql Server &nbsp;is TimeSpan ( <a href="http://msdn.microsoft.com/en-us/library/cc716729.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/cc716729.aspx</a>&nbsp;) <br />
<br />
you can conver it like this, but you have to use the field INDEX instead of the field name<br />
<br />
Dim tsStartTime As TimeSpan = CType(reader(indexofstartt<wbr />imefield),<wbr /> TimeSpan)<br />
<br />

</div>


Hi,

The vb.net datatype equivalent for  Time datatype of sql Server  is TimeSpan ( http://msdn.microsoft.com/en-us/library/cc716729.aspx [http://msdn.microsoft.com/en-us/library/cc716729.aspx] )

you can conver it like this, but you have to use the field INDEX instead of the field name

Dim tsStartTime As TimeSpan = CType(reader(indexofstarttimefield), TimeSpan)



<div>
You could just convert the variable to a date string in the way you need it.<br />
<br />
varToConvert<br />
<br />
cdate(varToConvert).ToStri<wbr />ng(&quot;yyyy-M<wbr />M-dd&quot;) -&gt; Date is 2011-03-18<br />
<br />
cdate(varToConvert).ToStri<wbr />ng(&quot;HH:mm&quot;<wbr />) -&gt; Time is military time
</div>


You could just convert the variable to a date string in the way you need it.

varToConvert

cdate(varToConvert).ToString("yyyy-MM-dd") -> Date is 2011-03-18

cdate(varToConvert).ToString("HH:mm") -> Time is military time

<div>
<div class="content wysiwyg-content">
Hi<br />
I have two fields in a SQL database that are of types: time(7) and date.<br />
I am reading data out of Excel that needs to be converted to these formats.<br />
What VB.net code would I use?<br />
All I can find so far is a conversion to date and time &nbsp;together<br />
eg Dim oStartTime As String = Convert.ToDateTime(reader(<wbr />&quot;Start time&quot;))<br />

</div>
</div>


Hi
I have two fields in a SQL database that are of types: time(7) and date.
I am reading data out of Excel that needs to be converted to these formats.
What VB.net code would I use?
All I can find so far is a conversion to date and time  together
eg Dim oStartTime As String = Convert.ToDateTime(reader("Start time"))


ASP.net converting data types

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.