On Sep 29, 2005, at 5:12 , Lane Van Ingen wrote:
> select into current_date_time10 to_char
> (localtimestamp,'HH24:MI:SS.US');
> RAISE NOTICE 'LINK TYPE(5) %',current_date_time10;
<snip />
> It almost looks like the system's time is not polled every time a
> request is
> made for time.
>
> Is there another way to do this?
I suggest you read the documentation on date/time functions, in
particular:
http://www.postgresql.org/docs/current/static/functions-
datetime.html#FUNCTIONS-DATETIME-CURRENT
I think you'll find what you're looking for.
Michael Glaesemann
grzm myrealbox com