Subject Re: [firebird-support] inserting timestamp using 'NOW' does't store milliseconds
Author Helen Borrie
At 01:14 AM 4/05/2006, you wrote:
>I am tring to insert timestamp using "NOW" function to my table.
>My code looks like:
>INSERT INTO MY_TABLE (MY_TIMESTAMP) VALUES ('NOW')
>
>I am not getting milliseconds back from the database.
>
>My PC: Fedora Core4, Firebird 1.5CS (Dialect 3)
>
>Thanks for your advices and/or comments.

That's a platform shortfall currently. You *can* get an exact
timestamp using the UDF GetExactTimestamp() (in FBUDF)

./HElEN