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: 3D925AB5.2010203@heart.com.au (view raw or flat)
Thread:
Lists: 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



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-2014 The PostgreSQL Global Development Group