Subject | timestamp on FB 1.5 |
---|---|
Author | ivory intercode |
Post date | 2009-02-12T11:00:52Z |
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.
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.