Inserting a timestamp into Firebird:

'2002-10-02 13:41:12.171'

yields the following results on a select ...
iSQL: '2002-10-02 13:41:12.171'
IBConsole's iSQL: '2002-10-02 13:41:12'
Firebird-Java: '2002-10-02 13:41:12'

So I assume, that firebird has the exact value but the java driver
(and IBConsole too) delivers it truncated?

(same question in the following messages:
http://groups.yahoo.com/group/Firebird-Java/message/1754
http://groups.yahoo.com/group/Firebird-Java/message/1520
http://groups.yahoo.com/group/Firebird-Java/message/926
)

Just wanted to ask if anybody has a workaround before I dig into the
sources.

Sven