Re: Timestamp Error - Mailing list pgsql-odbc

From Keith Gray
Subject Re: Timestamp Error
Date
Msg-id 3D925AB5.2010203@heart.com.au
Whole thread Raw
In response to Timestamp Error  (Keith Gray <keith@heart.com.au>)
List pgsql-odbc
Hiroshi Inoue wrote:

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

VB6 ADO

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



pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: IODBC32.DLL: Access Violation
Next
From: "CN LIOU"
Date:
Subject: Re: IODBC32.DLL: Access Violation