Re: Timestamps Look Incorrect? - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: Timestamps Look Incorrect?
Date
Msg-id 5F9E4612-9364-43D7-AD23-05627B3C7CFB@myrealbox.com
Whole thread Raw
In response to Timestamps Look Incorrect?  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-novice
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




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamps Look Incorrect?
Next
From: shadowbox
Date:
Subject: Re: stored procedure problem: parameters not properly passed