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

Re: .3RC2 does not have datetime() function?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: .3RC2 does not have datetime() function?
Date: 2002-11-27 16:05:57
Message-ID: 17810.1038413157@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> Don't know if this is a bug or not but ... this query worked under 7.2.1 
> but doesn't under 7.3RC2. datetime was a built-in function in 7.2.1 but 
> seems to be "missing" from 7.3RC2 ...

> $ psql JC -c "select to_char(datetime(upload_time),'YYYY-MM-DD') as 
> utime from products where id='989000627108' "
> ERROR:  Function datetime(timestamp without time zone) does not exist

You shouldn't have been using datetime() here anyway, AFAICS --- the
input was already a timestamp, so what was the point?

But yes, we deprecated that type name for two versions and it's now gone
completely.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-27 16:10:28
Subject: Re: createdb script bug in 7.3RC2?
Previous:From: Rod TaylorDate: 2002-11-27 13:23:10
Subject: Re: regression hickups w/ freebsd.

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