Re: [GENERAL] timeofday() and CAST

2003-08-26 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Hmm... I'm seeing Chile standard timezones, so it's not a matter of how > big the country is. However, in the table at > src/backend/utils/adt/datetime.c I'm seeing conflict between BST > (British Summer Time), BST (Brazil Standard Time) and BST (Bering

Re: [GENERAL] timeofday() and CAST

2003-08-21 Thread Vilson farias
ilson farias" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "SIMONE Carla MOSENA" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 11:40 AM Subject: Re: [GENERAL] timeofday() and CAST > "Vilson farias"

Re: [GENERAL] timeofday() and CAST

2003-08-21 Thread Tom Lane
"Vilson farias" <[EMAIL PROTECTED]> 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 r