Jorge
GetDateTime() is a method on the MySqlDateTime object. To use it from a
reader you would do: reader.GetMySqlDateTime(index). To use it from the
reader using GetValue you would do
((MySqlDateTime)reader.GetValue(index)).GetDateTime().
Also note that with 1.0.3, this behavior is dependent on the value of the
"allow zero datetime" connection string option.
-reggie
> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: Monday, December 13, 2004 8:19 AM
> To: dotnet@stripped
> Subject: Re: datetime
>
> Barry,
>
> Dataposto.Value = myrd.Item("postodata").GetDateTime
>
> I don't have the option ".GetDateTime" in this away
>
>
> ----- Original Message -----
> From: "Barry Zubel" <barry@stripped>
> To: "'Jorge Bastos'" <mysql.jorge@stripped>; <dotnet@stripped>
> Sent: Thursday, December 09, 2004 5:30 PM
> Subject: RE: datetime
>
>
> Currently, datetimes are being returned as a MySqlDateTime to allow for
> dates like 0000-00-00. To return it as a .Net date/time, you need to
> convert
> using one of the following:
>
> Dataposto.Value = CDate(myrd.Item("postodata").ToString())
> Dataposto.Value = Ctype(myrd.Item("postodata"),
> Mysql.Data.Types.MySqlDateTime).GetDateTime
>
> Or, for loose binding:
>
> Dataposto.Value = myrd.Item("postodata").GetDateTime
>
> Reggie has asked for comments regarding this behaviour on here, so it may
> be
> subject to change. AT the moment, I believe the safest method is to use
> .ToString with a Cdate conversion.
>
> B.
>
> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: 09 December 2004 17:11
> To: dotnet@stripped
> Subject: datetime
>
>
> DecimalHi,
>
> In old bytefx i used this sintax
> dataposto.Value = myrd.Item("postodata")
>
>
> Using the new driver, in verstion 1.0.2 i get an exeption as shown below:
>
> Cast from type 'MySqlDateTime' to type 'Date' is not valid.
>
>
>
> How to use the new value?
>
> Jorge Bastos
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
>
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1
