From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | Linn Kubler <LKubler(at)ecw(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Formatting date question |
Date: | 2002-08-22 21:17:27 |
Message-ID: | Pine.LNX.4.21.0208222215110.1042-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | cnliou | 2002-08-23 01:04:15 | Controling Rule's Firing Order |
Previous Message | Linn Kubler | 2002-08-22 21:11:55 | Formatting date question |