How to use dates in WHERE in SQL Server

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to use dates in WHERE in SQL Server

Message

From

10/06/2008 16:49:52

10/06/2008 13:47:01

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

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Miscellaneous

Thread ID:

01322704

Message ID:

01322928

Views:

>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