Formatting date question

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