Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones - Mailing list pgsql-bugs

From Todd A. Cook
Subject Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
Date
Msg-id 48B55EC5.8080805@blackducksoftware.com
Whole thread Raw
In response to Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4381: Postgresql daemon won't stay in the foreground
Next
From: Tom Wright
Date:
Subject: Re: BUG #4381: Postgresql daemon won't stay in the foreground