Re: Upgrade 7.2.1 to 7.3.4 datetime Error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: koprahome(at)telkom(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade 7.2.1 to 7.3.4 datetime Error
Date: 2003-10-01 14:17:32
Message-ID: 28858.1065017852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Eko Pranoto <koprapostgres(at)telkom(dot)net> writes:
> select datetime(now()) as result' LANGUAGE 'sql';

"datetime" isn't a standard type name anymore. Use "timestamp".

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott 2003-10-01 14:36:15 leading choices
Previous Message scott.marlowe 2003-10-01 13:44:35 Re: Upgrade 7.2.1 to 7.3.4 datetime Error