List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:December 13 2004 2:41pm
Subject:RE: datetime
View as plain text  
It should be out on the servers now.

> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: Monday, December 13, 2004 8:43 AM
> To: dotnet@stripped
> Subject: Re: datetime
> 
> ops
> thank's for the tip.
> you said that the new version (1.0.3) will come youa few days ago, do you
> have a day for it to come out?
> 
> Jorge Bastos
> 
> 
> ----- Original Message -----
> From: "Reggie Burnett" <reggie@stripped>
> To: "'Jorge Bastos'" <mysql.jorge@stripped>; <dotnet@stripped>
> Sent: Monday, December 13, 2004 2:37 PM
> Subject: RE: datetime
> 
> 
> > 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
> >
> >
> 
> 
> --
> 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