Re: BUG #5132: Invalid Function - Mailing list pgsql-bugs

On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap <geokhua8888@yahoo.com.sg> wr=
ote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05132
> Logged by: =A0 =A0 =A0 =A0 =A0Geok Hua Yap
> Email address: =A0 =A0 =A0geokhua8888@yahoo.com.sg
> PostgreSQL version: 8.3.1
> Operating system: =A0 CentOS 5.2
> Description: =A0 =A0 =A0 =A0Invalid Function
> Details:
>
> select timeofday()::timestamp;
> ERROR: =A0invalid input syntax for type timestamp: "Thu Oct 22 15:16:25.1=
13963
> 2009 SGT"

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

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

...Robert