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

.3RC2 does not have datetime() function?

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: .3RC2 does not have datetime() function?
Date: 2002-11-27 10:01:39
Message-ID: 3DE49803.3080801@mega-bucks.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugs
Sorry if this has been brought up before. I tried searching the archives 
at http://archives.postgresql.org/pgsql-bugs/ but it seems the search 
function is broke.

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
         Unable to identify a function that satisfies the given argument 
types
         You may need to add explicit typecasts

JC


Responses

pgsql-bugs by date

Next:From: Jean-Christian ImbeaultDate: 2002-11-27 11:37:31
Subject: createdb script bug in 7.3RC2?
Previous:From: Jean-Christian ImbeaultDate: 2002-11-27 08:48:31
Subject: 7.3RC2 does not have datetime() function?

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