Re: [Firebird-net-provider] DateTime conversion in Firebird.NET

[<car...@te...>]

Hello:

>I using version 1.5 of Firebird.NET provider and I noticed that DateTime
>does not convert 100% therefore failing if used in CompareTo.  What I
>noticed is that the time portion of the datetime is missing as indicated
>by the ticks count.  For example ....
>
>Write to Firebird 
>EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
>632186542302487500
>
>Read from Firebird
>EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
>632186542300000000
>

That works for me, are you sure the field in the database is
a timestamp field ?? ( i know it's stupid question but i need
to ask it :) ), date only fields doesn't have the time ;).

The only part that isn't handled in 1.5 version for a timestamp
field are the milliseconds (that is being done yet in 1.6)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain