How to use dates in WHERE in SQL Server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to use dates in WHERE in SQL Server

Message

10/06/2008 16:49:52

10/06/2008 13:47:01

Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Divers

Thread ID:

01322704

Message ID:

01322928

Vues:

>This one works
>
>

>SELECT COUNT(*)
>FROM [dbo].[log]
>WHERE action = 'THIS' AND log_date_time BETWEEN
>    '2008/01/01' AND '2008/03/31'
>
>

I didn't say it wouldn't. I said it is not the right way to do that.
Cetin