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.fff
However, when the .net data provider is returning the column data, it doesn't
send the milliseconds. I need this data because I'm using it as part of a
primary key.
example: using (FbConnection conn = new FbConnection())
{
conn.Open();
FbCommand command = new FbCommand("SELECT CURRENT_TIMESTAMP AS
some_date FROM RDB$DATABASE", conn);
FbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
throw new Exception(reader.getdToString());
}
}
Is this a bug? Is there a workaround?
------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
