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