ops you're right, i didn't went to see in the page before
Jorge
----- Original Message -----
From: "Reggie Burnett" <reggie@stripped>
To: "'Jorge Bastos'" <mysql.jorge@stripped>; <dotnet@stripped>
Sent: Monday, December 13, 2004 2:41 PM
Subject: RE: datetime
> 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
>
>
