On Thu, 08 Dec 2011 14:27:27 -0000, "firebirdsql" <firebirdsql@...>
wrote:

> --- 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.

I don't know enough about the innerworkings of the .NET provider, but I am
not sure your assumption is valid that this should return the 'raw data'.
But again: post it to the Firebird .NET provider list.