RE: to_char() causes backend to close connection

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: RE: to_char() causes backend to close connection
Date: 2000-12-14 16:02:20
Message-ID: 996802F75C3CD411B424001083FA445B05950A@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work

Ben

> -----Original Message-----
> From: Kovacs Zoltan Sandor [mailto:tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu]
> Sent: 14 December 2000 15:49
> To: Karel Zak
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] to_char() causes backend to close connection
>
>
> > 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 conversion.
>
> Any idea? TIA, Zoltan
>

Browse pgsql-sql by date

  From Date Subject
Next Message Tulio Oliveira 2000-12-14 18:05:43 Compiling "C" Functions
Previous Message Kovacs Zoltan Sandor 2000-12-14 15:48:31 Re: to_char() causes backend to close connection