Re: timeofday() and CAST - Mailing list pgsql-general

From Tom Lane
Subject Re: timeofday() and CAST
Date
Msg-id 7650.1061476839@sss.pgh.pa.us
Whole thread Raw
In response to timeofday() and CAST  ("Vilson farias" <vilson.farias@digitro.com.br>)
List pgsql-general
"Vilson farias" <vilson.farias@digitro.com.br> writes:
> #### PostgreSQL 7.3.4 ####

> bxs=# SELECT timeofday();
>               timeofday
> -------------------------------------
>  Thu Aug 21 10:04:18.215420 2003 BRT
> (1 row)

> bxs=# SELECT CAST(timeofday() AS timestamp);
> ERROR:  Bad timestamp external representation 'Thu Aug 21 10:04:42.597819
> 2003 BRT'
> bxs=#

It's unhappy about "BRT", which is not a known timezone name.  Not sure
why the earlier version didn't complain too.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: query optimization: aggregate and distinct
Next
From: Andrew Sullivan
Date:
Subject: Re: Buglist