Skip site navigation (1) Skip section navigation (2)

Re: Timestamp Error

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: ODBC PostgreSQL <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Timestamp Error
Date: 2002-09-26 00:54:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Hiroshi Inoue wrote:

>>We have moved from 7.1 to 7.2
>>Bad timestamp external representation ' '


ThisValue is a string like '2001-03-30' (*note non-US)

Select Case fldField.Type
  Case adDate, adDBDate, adDBTime, adDBTimeStamp
  If IsDate(ThisValue) Then
    fldField.Value = CDate(ThisValue)
  End If


The above was working with 7.1

Sorry, ipgsql works OK.
Have tested with pgAdmin2 no problems, but doesn't
show time portion of datetime (timestamp)


Keith Gray
Technical Services Manager
Heart Consulting Services

In response to

pgsql-odbc by date

Next:From: CN LIOUDate: 2002-09-26 08:54:07
Subject: Re: IODBC32.DLL: Access Violation
Previous:From: Hiroshi InoueDate: 2002-09-26 00:13:24
Subject: Re: IODBC32.DLL: Access Violation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group