Subject Re: Is this a bug in firebird .net provider?
Author firebirdsql
--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> 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
>




throw new Exception(reader["timestamp_column"].ToString()) should just throw whatever raw data the Firebird .net provider got from the db. So it looks like the bug is in the Firebird .net provider.