Subject Re: [firebird-support] Is this a bug in firebird .net provider?
Author Mark Rotteveel
On Thu, 08 Dec 2011 13:53:43 -0000, "firebirdsql" <firebirdsql@...>
wrote:
> I have a table with a timestamp column in Firebird 2.5. The format for
> timestamps in Firebird is dd-MM-yyyy hh:mm:ss:fffff (microseconds).
>
> However, when the .net data provider is returning the column data, it
> doesn't send the microseconds.
>
> example:
> using(FbDataReader reader = command.ExecuteReader())
> {
> throw new Exception(reader["timestamp_column"].ToString()); //Return
> the column data as a string to see what was sent back
> }
>
> How can I get the microseconds (basically the exact data in the column)?

This question is probably better suited for the Firebird .NET provider
mailinglist. Are you sure that the datatype used in .NET actually has
millisecond (not microsecond) precision?

Mark