Myles
TDateTime is only accurate to a millisecond what do you mean rounded
BTW is there a better way of just getting the date part of a DateTime than
create proc ReportOnDate @Date DateTime
as
begin
declare
@DateOnly datetime
set DateOnly = DateAdd(dd,DateDiff(dd,'1/1/99',@Date),'1/1/99')
.....
end
----- Original Message -----
From: Myles Penlington <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 6 April 2000 16:14
Subject: RE: [DUG]: ADO Bugs?
> It's okay now. I have fixed it - it was my bug in the end.
>
> I am using SQLOLEDB.
>
> Also found that DATETIME as a parameter to a STORED PROCEDURE appear to
have
> it's milliseconds rounded.
>
> Myles.
>
>
> > -----Original Message-----
> > From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, 6 April 2000 17:12
> > To: Multiple recipients of list delphi
> > Subject: Re: [DUG]: ADO Bugs?
> >
> > Myles
> >
> > Which Provider are you using
> >
> > Regards Neven
> > N.K. MacEwan B.E. E&E
> > [EMAIL PROTECTED]
> >
> >
> > ----- Original Message -----
> > From: Myles Penlington <[EMAIL PROTECTED]>
> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> > Sent: Thursday, 6 April 2000 14:52
> > Subject: [DUG]: ADO Bugs?
> >
> >
> > > Does anybody know of problems with SQL7 fields dealing with BINARY,
> > > VARBINARY or TIMESTAMP datatypes.
> > > I am trying to pass these to a STORED PROC adn to get data back from
an
> > ADO
> > > STORED PROC, but alas no luck.
> > >
> > > The data comes back NULL from the select statement. This is in D5.01
> > C/S.
> > >
> > > The SQL works fine from the SQL Query analyser.
> > >
> > > Thanks.
> > >
> > > Myles Penlington
> > >
> > >
>
> --------------------------------------------------------------------------
> > -
> > > New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
> > > Website: http://www.delphi.org.nz
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
