Alex
SQL 2000 is in beta now avail go to
http://www.microsoft.com/sql/productinfo/sql2kover.htm
MSDE is rolling along they are talking about SQL2000 for windows CE!
Regards Neven
N.K. MacEwan B.E. E&E
[EMAIL PROTECTED]
----- Original Message -----
From: Alex Kouznetsov <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 1 June 2000 17:27
Subject: Re: [DUG]: Date portion of MSSQL datetime data type
> Thanks Neven
>
> Do you know when SQL2000 is due ?
>
> Also what is going to happen with MSDN concept ? There used to be rumors
> while ago about building SQL server into Windows in some form. Is it
> happenning ? Or it will be once again add-on for MS developers. Or
something
> else ?
>
> Alex
>
> ----- Original Message -----
> From: "Neven MacEwan" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Thursday, 01 June, 2000 3:47 PM
> Subject: Re: [DUG]: Date portion of MSSQL datetime data type
>
>
> > Alex
> >
> > Roll on SQL 2000 with user defined functions
> > The DatePart function will the first written
> >
> > re
> >
> > > Say I want records from 1/05/2000 to 30/05/2000 and my logged column
is
> of
> > > datetime type.
> > >
> >
> > SELECT * FROM mytable WHERE logged >= '2000-05-01' AND logged <
> > '2000-06-01'
> > will work
> >
> > (prob a bad example)
> >
> > Regards Neven
> > N.K. MacEwan B.E. E&E
> > [EMAIL PROTECTED]
> >
> >
> > ----- Original Message -----
> > From: Alex Kouznetsov <[EMAIL PROTECTED]>
> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> > Sent: Thursday, 1 June 2000 16:23
> > Subject: [DUG]: Date portion of MSSQL datetime data type
> >
> >
> > > Hi
> > >
> > > I could not find any simple DatePart function in MSSQL to extract date
> > > portion from datetime columns.
> > > What is the best way to compare dates with the values in the datetime
> > column
> > > ignoring its time portion ?
> > >
> > > I found this working but a bit ugly:
> > >
> > > Say I want records from 1/05/2000 to 30/05/2000 and my logged column
is
> of
> > > datetime type.
> > >
> > > SELECT * FROM mytable WHERE DATEDIFF(day, logged, '2000-05-01') <= 0
and
> > > DATEDIFF(day, logged, '2000-05-30') >= 0
> > >
> > > Any better ways to do this ?
> > >
> > >
> > > Thanks
> > > Alex
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > > 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
