We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

MySqlDataReader for TIME ?

pillmill
pillmill asked
on
Medium Priority
231 Views
Last Modified: 2013-12-17
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 ?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2004

Commented:
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

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

Author

Commented:
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.
CERTIFIED EXPERT
Top Expert 2004
Commented:
You can use data conversion commands in the SQL.  Use CAST/CONVERT to return another data type that you want instead.  

http://dev.mysql.com/doc/refman/5.1/en/cast-functions.html

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.