"Geok Hua Yap" writes:
> select timeofday()::timestamp;
> ERROR: invalid input syntax for type timestamp: "Thu Oct 22 15:16:25.113963
> 2009 SGT"
SGT was added to the default set of timezone abbreviations as of 8.4.
If you want to use Singapore timezone in 8.3, you'll probably want to
add it to
On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap 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: Inval
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
