Re: to_char() causes backend to close connection

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: to_char() causes backend to close connection
Date: 2000-12-14 15:48:31
Message-ID: Pine.LNX.4.05.10012141645090.9225-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Trewern, Ben 2000-12-14 16:02:20 RE: to_char() causes backend to close connection
Previous Message Franklin Vera 2000-12-14 14:24:59 Howto compile fti.c