Dennis
2 function calls and a type change so no prize..I'll keep it in mind tho
Thanks
Neven
----- Original Message -----
From: Dennis Chuah <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 6 April 2000 17:13
Subject: RE: [DUG]: ADO Bugs?
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
