<div>
Looks like there isn't one. &nbsp;There are readers for timespan, system.datetime, or mysqldatetime.<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/connector-net-examples-mysqldatareader.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.1/en/connector-net-examples-mysqldatareader.html</a><br />
<br />
The next seems to imply that you should be using the mysqldatetime object instead:<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/connector-net-using-datetime.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.1/en/connector-net-using-datetime.html</a><br />
<br />

</div>


Looks like there isn't one.  There are readers for timespan, system.datetime, or mysqldatetime.

http://dev.mysql.com/doc/refman/5.1/en/connector-net-examples-mysqldatareader.html [http://dev.mysql.com/doc/refman/5.1/en/connector-net-examples-mysqldatareader.html]

The next seems to imply that you should be using the mysqldatetime object instead:

http://dev.mysql.com/doc/refman/5.1/en/connector-net-using-datetime.html [http://dev.mysql.com/doc/refman/5.1/en/connector-net-using-datetime.html]



<div>
OK. Is there a way then, to output the results so that the output is either:<br />
a date(yyyy,mm,dd) OR a time (hr,min,sec) ? Thanks.
</div>


OK. Is there a way then, to output the results so that the output is either:
a date(yyyy,mm,dd) OR a time (hr,min,sec) ? Thanks.

<div>
<div class="content wysiwyg-content">
When I try to read the MySql database field of type &quot;TIME&quot;, using the MySql datareader, I get the following error:<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp; &nbsp;'MySql.Data.MySqlClient.My<wbr />SqlDataRea<wbr />der' does not contain a definition for 'GetTime' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
I can read DateTime type, but not Time. So, how can I read the field of type TIME ?
</div>
</div>


When I try to read the MySql database field of type "TIME", using the MySql datareader, I get the following error:
	
   'MySql.Data.MySqlClient.MySqlDataReader' does not contain a definition for 'GetTime'	

I can read DateTime type, but not Time. So, how can I read the field of type TIME ?

MySqlDataReader for TIME ?

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.