Re: [SQL] to_char() causes backend to close connection

[Kovacs Zoltan Sandor]

>  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