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

[Chris W. <ch...@co...>]

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


I don't know if this is an issue with the provider or with the native
Firebird layer used by the provider.  If this a problem of DateTime to
TimeStamp translation at the native level then I can work around this
issue by defining time in my data base as ticks using a bigint.

Thanks,
Chris