Skip site navigation (1) Skip section navigation (2)

RE: to_char() causes backend to close connection

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: RE: to_char() causes backend to close connection
Date: 2000-12-14 16:02:20
Message-ID: 996802F75C3CD411B424001083FA445B05950A@CET_PONXX_FP001 (view raw or flat)
Thread:
Lists: pgsql-sql
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
> 

pgsql-sql by date

Next:From: Tulio OliveiraDate: 2000-12-14 18:05:43
Subject: Compiling "C" Functions
Previous:From: Kovacs Zoltan SandorDate: 2000-12-14 15:48:31
Subject: Re: to_char() causes backend to close connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group