<p><font size="2">select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work</font><p><font
size="2">Ben</font><p><fontsize="2">> -----Original Message-----</font><br /><font size="2">> From: Kovacs Zoltan
Sandor[<a href="mailto:tip@pc10.radnoti-szeged.sulinet.hu">mailto:tip@pc10.radnoti-szeged.sulinet.hu</a>]</font><br
/><fontsize="2">> Sent: 14 December 2000 15:49</font><br /><font size="2">> To: Karel Zak</font><br /><font
size="2">>Cc: pgsql-sql@postgresql.org</font><br /><font size="2">> Subject: Re: [SQL] to_char() causes backend
toclose connection</font><br /><font size="2">> </font><br /><font size="2">> </font><br /><font size="2">>
> A problem (IMHO it's not problem) with 'now()::abstime' is </font><br /><font size="2">> in 7.1 too. </font><br
/><fontsize="2">> > But why you not use directly now()?</font><br /><font size="2">> My aim is to get this
formatfor the time '5 minutes ago'. So I need</font><br /><font size="2">> something like</font><br /><font
size="2">></font><br /><font size="2">> select to_char(now()-'5 minutes','YYMMDDHH24MI')</font><br /><font
size="2">></font><br /><font size="2">> but this doesn't work due to the missing type conversion.</font><br
/><fontsize="2">> </font><br /><font size="2">> Any idea? TIA, Zoltan</font><br /><font size="2">> </font>