At 11:13 AM 14/04/2003 +0300, you wrote:

>Hi,
>
>Can anybody tell me what's the granularity of a timestamp field in
>Firebird and Interbase.

The timestamp type is capable of storing up to ten-thousandths of a
second. However, CURRENT_TIMESTAMP, CURRENT_TIME and the date literal
'NOW' do not store anything finer than seconds. If your server is on
Windows, you can use the UDF from FBUDF.dll, GetExactTimeStamp, to get a
timestamp with ten-thousandths of a second.

>Can I use it as a version number to implement optimistic locking.

Firebird already does optimistic locking...what did you have in mind?

heLen