From: Jorge Bastos Date: December 13 2004 2:42pm Subject: Re: datetime List-Archive: http://lists.mysql.com/dotnet/271 Message-Id: <00e401c4e122$02c72600$0301a8c0@pcjorge> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit 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" To: "'Jorge Bastos'" ; 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" >> To: "'Jorge Bastos'" ; >> 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=mysql.jorge@stripped >> >> >> >> -- >> MySQL on .NET Mailing List >> For list archives: http://lists.mysql.com/dotnet >> To unsubscribe: http://lists.mysql.com/dotnet?unsub=reggie@stripped > >