RE: 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: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
>