Use CONVERT to convert the datetime to a varchar (use a format that only
sends the date part), then CONVERT the varchar to DATETIME.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Neven MacEwan
> Sent: Thursday, 6 April 2000 17:26
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: ADO Bugs?
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
