At 03:23 AM 01-12-02 +0000, you wrote:

>--- In IBObjects@y..., Paul Vinkenoog <paulvink@s...> wrote:
> >
> > I think CURRENT_TIMESTAMP ought to work.
> >
>
>Thanks a lot! I cannot find detail mention of these date functions in
>the IB6 manual (downloaded from borland). I will be grateful if you
>could give me pointer to better IB6 documentation, so that I don't
>need to ask stupid questions in this list.

Well, you would have found doc of date literals in the DataDef.pdf. You
could have used CAST('NOW' AS TIMESTAMP). It gives you a more accurate
timestamp, since CURRENT_TIMESTAMP stays constant throughout a transaction,
whereas 'NOW' gives you the timestamp at the moment the update or insert
occurs.

A lot of the documentation changes for IB 6 can be found in the Migration
Guide and in the IB 6.0 release notes.

Firebird manuals are available from IB Phoenix, on their CD. An updated
version is due out this week. Not free: but you get a feast of goodies on
the CD.

Helen