straight out of the recordset. select from r> will list proper value,
ottero will not list proper value. date field *will* list just a date, but
time field will list date and time.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Dennis McGrath
> Sent: Thursday, August 23, 2001 7:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Oterro and Time Field
>
>
> 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
>
