Very strange. Are you sure VB is not doing a translation? Use the immediate
window and display the value right out of the recordset. That will tell you
more about what Oterro is actually retreiving.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Tools for R:BASE programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with SQL Resources
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Ron Rose
Sent: Wednesday, August 22, 2001 5:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Oterro and Time Field
SET VAR vtextract = (TEXTRACT(.vdatetime))
returns the TIME portion.
RRR
"Crued @ Crued.net" wrote:
>
> I have a field in my DB defined as TIME. When I retrieve the field using
> Oterro (w/ ADO 2.7), instead of getting just a time like '09:00', I get
the
> current date along with the time '08/22/2001 09:00'. Anybody have any
> ideas?
>
> Thanks,
> Eric
