Re: BUG #5132: Invalid Function

On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap <geokhua8888(at)yahoo(dot)com(dot)sg> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5132
> Logged by:          Geok Hua Yap
> Email address:      geokhua8888(at)yahoo(dot)com(dot)sg
> PostgreSQL version: 8.3.1
> Operating system:   CentOS 5.2
> Description:        Invalid Function
> Details:
>
> select timeofday()::timestamp;
> ERROR:  invalid input syntax for type timestamp: "Thu Oct 22 15:16:25.113963
> 2009 SGT"

This is not a bug. timeofday() returns text - maybe you want clock_timestamp()?

http://www.postgresql.org/docs/current/interactive/functions-datetime.html

...Robert