Posted by Erland Sommarskog on 07/22/05 18:52

Fernand St-Georges (fernand.st-georges@videotron.ca) writes:
> I got the value I needed using this type of query
> WHERE (dbo.Membre.Date_MAJ > GETDATE() - 1) AND (dbo.Membre.Date_MAJ <
> GETDATE() + 1)
> I only thought this would do
> where date_MAJ = GETDATE()
>
> while in Access I only need
> where date_MAJ =DATE()
>
> kind of amazing isn't it

No, it's not all amazing. Access and SQL Server are two very different
products, and if you try to use SQL Server as if it was Access you
are in for a hard time.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Update queries using more than one table
• Prev in forum: Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?
• Thread view: Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?

[Reply to this message]