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
> To: Karel Zak
> Cc: [EMAIL PROTECTED]
> 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
>
