|Subject||Re: inserting timestamp using 'NOW' does't store milliseconds|
--- In email@example.com, Helen Borrie <helebor@...> wrote:
>Thanks Helen, it works like a charm. :)
> 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)