Обсуждение: Formatting date question

Hi,

I'm using a database program to query my postgres backend and I'm
trying to convert a timestamp to a date for display purposes.  In psql I
can use to_char() and it works fine but that command doesn't work in my
database applications sql select statement, just gives a syntax error.
Of course if I try using the similar command from the database
application the query fails.  I'm using Visual Fox Pro via odbc, they
call it sql passthru.

Any suggestions?

Thanks in advance,
Linn

On Thu, 22 Aug 2002, Linn Kubler wrote:

> Hi,
>
> I'm using a database program to query my postgres backend and I'm
> trying to convert a timestamp to a date for display purposes.  In psql I
> can use to_char() and it works fine but that command doesn't work in my
> database applications sql select statement, just gives a syntax error.
> Of course if I try using the similar command from the database
> application the query fails.  I'm using Visual Fox Pro via odbc, they
> call it sql passthru.
>
> Any suggestions?

I know nothing of the odbc interface but seeing as this turned up as I was
posting another message...

Perhaps you need to escape quotation marks when supplying the query string in
Foxpro and/or odbc.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants