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
You may need to add explicit typecasts
pgsql-bugs by date
|Next:||From: Jean-Christian Imbeault||Date: 2002-11-27 11:37:31|
|Subject: createdb script bug in 7.3RC2?|
|Previous:||From: Jean-Christian Imbeault||Date: 2002-11-27 08:48:31|
|Subject: 7.3RC2 does not have datetime() function?|