3 messages in com.mysql.lists.dotnetUsing MySQL dates in vb.net using the...
FromSent OnAttachments
jan....@hoerbiger.com11 Mar 2005 07:37 
Kevin Turner11 Mar 2005 07:52 
Reggie Burnett15 Mar 2005 07:44 
Subject:Using MySQL dates in vb.net using the ODBC connector
From:jan....@hoerbiger.com (jan.@hoerbiger.com)
Date:03/11/2005 07:37:57 AM
List:com.mysql.lists.dotnet

Hi all,

I try to read dates from a MySQL database. My application is in VB.Net, I use the ODBC connector version 3.51.

My code :

With ReturnedDataReader Private mCreatedOn As Date Try mCreatedOn = .GetDateTime(4) 'This worked fine with MS Access and SQL Server Catch ex As Exception Try ' datetimes are being returned as a MySqlDateTime What should I do here to retrieve a valid DateTime from MySQL ? I have no clue ... Catch ex2 As Exception mCreatedOn = Date.MinValue End Try End Try

Thanks for any help offered !

Jan