The following bug has been logged online:
Bug reference: 5132
Logged by: Geok Hua Yap
Email address: geokhua8888@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"