Re: timeofday() and CAST

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org, "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br>, paulo(dot)pizarro(at)digitro(dot)com(dot)br
Subject: Re: timeofday() and CAST
Date: 2003-08-21 14:40:39
Message-ID: 7650.1061476839@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-21 14:59:21 Re: Buglist
Previous Message Shridhar Daithankar 2003-08-21 14:18:29 Re: [pgsql-advocacy] Need concrete "Why Postgres not MySQL"