List:MySQL and .NET« Previous MessageNext Message »
From:Jorge Bastos Date:December 13 2004 2:42pm
Subject:Re: datetime
View as plain text  
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
>
> 

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