Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones

From: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
Date: 2008-08-27 14:03:49
Message-ID: 48B55EC5.8080805@blackducksoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
>
> In the meantime, why aren't you just using clock_timestamp()?
> timeofday() is deprecated.

I am using clock_timestamp() now. The use of timeofday() was from the era
when 8.0 was hot stuff.

BTW, the word "deprecated" does not appear on the docs page where timeofday()
is listed (http://www.postgresql.org/docs/8.3/static/functions-datetime.html)
and there doesn't seem to be anything in the context of the 3 occurrences of
"timeofday" that would imply it is deprecated.

-- todd

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Wright 2008-08-27 14:14:43 Re: BUG #4381: Postgresql daemon won't stay in the foreground
Previous Message Tom Lane 2008-08-27 13:59:11 Re: BUG #4381: Postgresql daemon won't stay in the foreground