On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap <geokhua8...@yahoo.com.sg> wrote: > > The following bug has been logged online: > > Bug reference: 5132 > Logged by: Geok Hua Yap > Email address: geokhua8...@yahoo.com.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
