Roy Damman wrote:

> I have a problem when running my Firebird server under Linux. This
> concerns inserting / updating records with a column value for a
> timestamp field with the value NOW. When inserting / updating records
> the server uses the current date/time of the server. Running Firebird
> under Windows the timestamp has a resolution of 1 second but under Linux
> the timestamp seems to have a resolution of 1/10000 second. But when
> using the isc_decode_timestamp to decode this timestamp from the server,
> the high resolution part gets lost. This is problematic when updating
> records using a "last changed" timestamp. If you compare your read
> version of the timestamp (1 sec resolution) with the value in the
> database (1/10000 second resolution), the result will be (almost) always
> false. So the big question is: Is there a high resolution
> isc_decode_timestamp available or does someone have another solution?

Do you need the high resolution for your application? If not, your could
always round or truncate the Linux timestamp before inserting it.

What are you trying to do? I mean, how do you want to use the timestamps?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64