From: | <kaiq(at)realtyideas(dot)com> |
---|---|
To: | greg(at)proterians(dot)net |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] parse error ??? |
Date: | 1999-12-09 16:55:18 |
Message-ID: | Pine.LNX.4.10.9912091049190.27698-100000@picasso.realtyideas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
cast is not necessarily extract, if you really want portablility,
use extract(), which is sql92.
select extract (day from d1) from datetime_tbl;
On Thu, 9 Dec 1999 greg(at)proterians(dot)net wrote:
>
> I have one question...
>
> Why postgres returns parse error when i send
>
> select birth_time::date from table;
>
>
> parse error at or near ":"
>
>
> I use CBuilder4 and postODBC driver...
>
>
> when I write
>
> select date(birth_time) from table;
>
> it works...
>
>
> but in DataBaseExplorer the first query works fine....
>
>
> please help....
>
>
> --Greg--
>
>
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 1999-12-09 17:57:32 | Re: [GENERAL] get the previous assigned sequence value |
Previous Message | Bruce Momjian | 1999-12-09 16:50:13 | Re: [GENERAL] Problems with pg_dump |