select cast ('now' as timestamp)
from rdb$database

return the time for me in Firebird 1.5.

Are you sure that datecome is defined as timestamp and not as date and that the database is dialect 3 (and needless to say, that you didn't run the query exactly at midnight ;o} )?

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of ivory intercode
Sent: 12. februar 2009 12:01
To: firebird-support@yahoogroups.com
Subject: [firebird-support] timestamp on FB 1.5

Dear ALL,


How to fill my timestamp field so it should be like this '12.02.2009 09:16'.
I've tried this syntax

*set table1.datecome = current_timestamp*

and either

*set table1.datecome = cast('now' as timestamp)*,

but it's still doesn't work correctly.
The result still '12.02.2009 00:00'.

Please help. (PS : my FB is 1.5 and Dialect3)

many thanks for every reply.
frank.