| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | "Lane Van Ingen" <lvaningen(at)esncc(dot)com> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Timestamps Look Incorrect? |
| Date: | 2005-09-28 21:33:10 |
| Message-ID: | 5F9E4612-9364-43D7-AD23-05627B3C7CFB@myrealbox.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shadowbox | 2005-09-29 03:14:51 | Re: stored procedure problem: parameters not properly passed |
| Previous Message | Tom Lane | 2005-09-28 21:30:45 | Re: Timestamps Look Incorrect? |