List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:December 10 2004 3:26am
Subject:RE: datetime
View as plain text  
I'll be releasing a new build tomorrow that will modify this behavior some.
I'll post complete details of the change in the release announcement.  

-reggie

> -----Original Message-----
> From: Barry Zubel [mailto:barry@stripped]
> Sent: Thursday, December 09, 2004 11:30 AM
> To: 'Jorge Bastos'; dotnet@stripped
> 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


Thread
datetimeJorge Bastos9 Dec
  • RE: datetimeBarry Zubel9 Dec
    • Re: datetimeJorge Bastos9 Dec
    • RE: datetimeReggie Burnett10 Dec
    • Re: datetimeJorge Bastos13 Dec
      • RE: datetimeReggie Burnett13 Dec
        • Re: datetimeJorge Bastos13 Dec
          • RE: datetimeReggie Burnett13 Dec
            • Re: datetimeJorge Bastos13 Dec