From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "frank_lupo" <frank_lupo(at)email(dot)it> |
Cc: | <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: problem ODBC |
Date: | 2002-07-25 09:29:38 |
Message-ID: | D85C66DA59BA044EB96AB9683819CF61137FA7@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> Sent: 25 July 2002 10:12
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: [pgadmin-hackers] problem ODBC
>
>
> > >
> > > Show datestyle
> > > -> DateStyle is ISO with European conventions
> > > select now()
> > > 25/07/2002 9.01.57
> > >
> > > Change date style
> > > SET datestyle TO 'SQL' or SET datestyle TO 'SQL,European'
> > > -> DateStyle is SQL with European conventions
> > > select now()
> > > In Visual Basic error -2147217887
> > >
> > > This problem is present also in PgAdmin2.
> > >
> > > Help me
> > >
> > When does the error occur in pgAdmin?
>
> The error occurs in window sql interactive.
> Try to insert in sequence the instructions listed in my previous
> message.
Ahh yes. I would expect that to happen. VB tries to interpret the dates
rather than handle them as text strings. The most reliable way of doing
this is to use ISO format - other formats may not be recognised by VB. I
always suggest people use ISO formatted dates on the server and to let
the client application reformat them to the local style as required.
E.g.
Text1.Text = Format(rs!datefield, "Long Date")
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Poul L. Christiansen | 2002-08-02 14:31:09 | datetime local bug |
Previous Message | Dave Page | 2002-07-25 09:12:38 | Re: problem ODBC |