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

Re: [BUGS] Datetime -> Timestamp conversion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christof Petig <christof(dot)petig(at)wtal(dot)de>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] Datetime -> Timestamp conversion
Date: 1999-08-25 14:51:59
Message-ID: 6306.935592719@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Christof Petig <christof(dot)petig(at)wtal(dot)de> writes:
> christof=> select timestamp(datetime 'now');
> ERROR:  No such function 'datetime_stamp' with the specified attributes

> christof=> select timestamp(abstime(datetime 'now'));
> [ OK ]

> It looks like if the SQL parser needs 'datetime_timestamp' , it looks
> for 'datetime_stamp' which doesn't exist!

Yes, there is an error in OID 1370 of the pg_proc table :-(.  I have a
to-do note to fix it for 6.6, but AFAIK we can't easily repair it
short of an initdb, so there will be no fix in the 6.5.* series.
You could probably poke it by hand in your local database, though,
if it's getting in your way.

> I read that TIMESTAMP (SQL92) shall replace DATETIME (PostgreSQL) in the
> future, has anybody signed this work, yet? Thomas Lockhart?

Lockhart's been muttering about doing that, but I don't know when he
plans to do it.

			regards, tom lane

pgsql-bugs by date

Next:From: Tom LaneDate: 1999-08-25 15:11:55
Subject: Re: [BUGS] Error in Makefile
Previous:From: Bruce MomjianDate: 1999-08-25 14:21:27
Subject: Re: [BUGS] Error in Makefile

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