Thread: parse error ???

   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--

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@proterians.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--
>
>
>
> ************
>