Re: [SQL] Date fields and libpq....

From: Colin Dick <cdick(at)mail(dot)ocis(dot)net>
To: Kachun Lee <kachun(at)pathlink(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Date fields and libpq....
Date: 1998-06-26 23:17:44
Message-ID: Pine.LNX.3.96.980626161054.30350B-100000@ocis.ocis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> It should be:
>
> select date_part(datetime(start),'epoch') from timebase;

Hi,
What version of postgres are you running? I have tried the above
query and get the following result:

WARN:func_get_detail: function date_part(datetime, unknown) does not exist

Is this perhaps something that has been written specifically for your
postgres or is it included in the latest version? I am currently running
version 6.1..... Thanks again for your fast responses.

--
Colin Dick
On Call Internet Services
cdick(at)mail(dot)ocis(dot)net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kachun Lee 1998-06-26 23:45:54 Re: [SQL] Date fields and libpq....
Previous Message Kachun Lee 1998-06-26 22:05:40 Re: [SQL] Date fields and libpq....