Title: RE: [SQL] to_char() causes backend to close connection
select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work
Ben
> -Original Message-
> From: Kovacs Zoltan Sandor [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2000 15:49
> A problem (IMHO it's not problem) with 'now()::abstime' is in 7.1 too.
> But why you not use directly now()?
My aim is to get this format for the time '5 minutes ago'. So I need
something like
select to_char(now()-'5 minutes','YYMMDDHH24MI')
but this doesn't work due to the missing type conv
On Thu, 14 Dec 2000, Kovacs Zoltan Sandor wrote:
> Hi, this query gives different strange results:
>
> select to_char(now()::abstime,'YYMMDDHH24MI');
the result:
ERROR: to_char/to_number(): not unique decimal poit
is right, because we have two to_char():
to_char(int, text)
Hi, this query gives different strange results:
select to_char(now()::abstime,'YYMMDDHH24MI');
I get e.g. a "backend closed the channel unexpectedly..." error with
successful or failed resetting attempt (indeterministic)
or
ERROR: to_char/to_number(): not unique decimal poit
or
NOTICE: Por
